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 “coerects” 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.

136 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
coerects125854(None) 
coerect11913351coerect_
corrects1259571corrects
codirects1493592codirects
coeffects1942462coeffects
coenacts1246402coenacts
coercers1237652coercers
coerces11311942coer_ces
coerected1447642coerected
coexerts1734882coexerts
collects12279782collects
confects153110872confects
connects123010562connects
convects153410992convects
correct11513982correct_
erects84116182__erects
reerects10319922reerects
berets85822523_bere_ts
carets85330773c_are_ts
cathects1545793cathects
cements112714223c_ements
cercis104614493c_er_cis
cercus105013153c_er_cus
cereals9313173c_ereals
ceres75540013c_ere__s
cereus85215523c_ere_us
cermets1139713c_ermets
chebecs1635013chebec_s
cheroots1348193cheroots
cherts115617233cher__ts
chevrets16255323chevre_ts
clarets94111103clare_ts
clerics1149333cleric_s
coacts105314333co__acts
coagents1138453coagents
cocreate122611813cocreate
cocreates132611883cocreates
codecs115112933co_dec_s
codirect13106293codirect_
coedits10310243coe_dits
coeffect1843933coeffect_
coempts1335683coe_mpts
coenact11311803coenact_
coerce10310403coer_c_e
coerced1238583coer_ced
coercer1138383coer_cer
coerecting15218783coerecting
coexert16312363coexert_
coexists1735653coexists
coffrets1645363coffre_ts
coherences1787043coherences
coherent13412473coherent_
coherers132310733cohere_rs
coheres122917693cohere__s
coinfects16344573coinfects
collect113314593collect_
collets93517903colle_ts
comets105823583co_me_ts
comments142913883comments
compacts16368903compacts
complects1766413complects
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concerts123016063concerts
concocts1138633concocts
conducts13118713conducts
confect143614273confect_
congests113510383congests
connect113515743connect_
consents102715893consents
contacts123215213contacts
contents104018213contents
contests103413383contests
contexts17378653contexts
contracts132212013contracts
convect143114483convect_
convents132614603convents
converts133213553converts
convicts15337713convicts
coparents1347973coparents
copecks1745873co_pecks
coquets18399893coque_ts
corers85231073co_re_rs
cores76361853co_re__s
cornets94820573co_rnets
corrected1438113corrected
correcter1348103correcter
correctest1445603correctest
correctly1644963correctly
corrector1347603corrector
correctors1447493correctors
corrupts1244983corrupts
corsets94819803co_rsets
corvets124715023co_rvets
cosecs105015213co_sec_s
cosets85824403co_se_ts
cossets95014283cosse_ts
courants10310803courants
courts84216173cour__ts
coverers132712123covere_rs
coverlets1437053coverlets
coverts124813813co_verts
covets114819643co_ve_ts
crests85218703c__rests
curets84922343c_ure_ts
currents1038373currents
defects134511523_defects
dejects17389223_dejects
detects104011093_detects
directs102710263_directs
ejects15409953__ejects
elects83315003__elects
erect74129333__erect_
eructs83610793__eructs
forests104114953fo_rests
gerents82612923_gerents
objects18123693_objects
overacts1339653overacts
overeats112415263overeats
perfects15107353_perfects
porrect1159743porrect_
preerects1345413preerects
prefects1598133prefects
prelects1299723prelects
reejects17336083reejects
reelects103110883reelects
reerect92915883reerect_
refects124012743_refects
rejects163910693_rejects
rerents73319423_rerents
resects94115593_resects
selects91912143_selects
solerets839693solere_ts
tercets93512443_tercets
torrents838143torrents

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621367.43619656.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.90522604.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.