Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “triacid” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
triacid103859(None) 
triacids1146721triacids
diacid10310632_diacid
traced94821582tr_aced
triac74116372triac__
triacs83913222triac_s
triad65217722tria__d
triadic1037832triadic
triaged92810442triaged
triazin1638202triazin
triced95518672tri_ced
trifid1039062tri_fid
trioxid1546612trioxid
acid77533403___acid
antacid10311223antacid
aramid93315613ar_amid
braced115420603br_aced
braid85822263br_a_id
briard94311293bria_rd
cricoid1239253cricoid
crinoid1039943crinoid
diacids1137863_diacids
ericoid1049893ericoid
frigid1136923fri_gid
graced105217903gr_aced
gravid113710983gr_avid
grimaced1463313grimaced
monacid121310243monacid
niacin8310223_niacin
nonacid101210843nonacid
oribatid1145463oribatid
oxyacid2062773oxyacid
peracid12312993peracid
placid114012543_placid
priapi1037923priapi_
priapic1346023priapic
priced115018883pri_ced
rabid84520783_r_abid
raced87635313_r_aced
raid55243083_r_a_id
rancid9513863_rancid
ranid66429333_r_anid
rapid86422033_r_apid
riced85825543_ri_ced
ricin74620213_ri_cin
rigid7913893_ri_gid
sialid7314943_sialid
striated93414153striated
subacid1248473subacid
tabanid1047333tabanid
tabid84418263t__abid
tacit76333673t__acit
teiid6312533tei__id
terraced11318133terraced
tetracid1147263tetracid
thiamin1236933thiamin
thiazide2143033thiazide
thiazin1945483thiazin
ticced11438443t_icced
timid84815733t_i_mid
tineid74412023t_ineid
trace75829613tr_ac_e
tracer84820233tr_acer
traces85329933tr_aces
tracheid1437583tr_acheid
tracing103720153tr_acing
track114823013tr_ac_k
tracked143716133tr_acked
tracks124818843tr_acks
tract75635713tr_ac_t
tracts85019073tr_acts
trad55630913tr_a__d
traded85717683tr_aded
tragi64717173tr_agi_
tragic93811553tr_agic
traik95418203tr_a_ik
traiked123310453traiked
trail55126773tr_a_il
trailed83415673trailed
train56529113tr_a_in
trained84117203trained
trait56940843tr_a_it
tranced104414173tranced
treacle939973treacle
treacly1237093treacly
tread64821703trea__d
treaded95014283treaded
treated83618703treated
trepid9310083tr_epid
triable92515393triable
triadics1146133triadics
triadism1147553triadism
triads74513533tria_ds
triage72812893tria_ge
triages82613793triages
triaging102610543triaging
trial54926353tria__l
trials64319883tria_ls
triarchy1643613triarchy
triassic1044633triassic
triaxial1545663triaxial
triazine1738503triazine
triazins1738353triazins
tribadic1344103tribadic
tribasic1244793tribasic
trice75127493tri_c_e
tricep103911073tri_cep
trices84826333tri_ces
trichoid1457813trichoid
tricing103417353tri_cing
trick115420693tri_c_k
tricked144016163tricked
trickie132611033trickie
tricks125319013tri_cks
tricky154211473tri_cky
triclad1037443triclad
tricot8317753tri_cot
tried65026913tri__ed
trifacial1444693trifacial
trifled113711963trifled
trifold1136243trifold
trigged10359853trigged
trilled84116313trilled
trimmed12348933trimmed
trined74920713tri_ned
trioxide1644793trioxide
trioxids1644443trioxids
tripack1565673tripac_k
tripacks1664893tripacks
tripled104113833tripled
triploid1147363triploid
tripod9399853tri_pod
tripped123911693tripped
trismic1137483trismic
trivia938513tri_via
troaked12438253troaked
truced95312053tr_uced
uracil8311543ur_acil
viscid1237473_viscid

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340271396.62620227.4
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.07525256.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.