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

167 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
corrects125957(None) 
coerects1258541coerects
correct11513981correct_
codirects1493592codirects
coerect11913352coerect_
collects12279782collects
confects153110872confects
connects123010562connects
convects153410992convects
cornets94820572corne_ts
corrected1438112corrected
correcter1348102correcter
correctest1445602correctest
correctly1644962correctly
corrector1347602corrector
correctors1447492correctors
corrupts1244982corrupts
corsets94819802corse_ts
corvets124715022corve_ts
currents1038372currents
porrect1159742porrect_
torrents838142torrents
acrolects1344333acrolects
arrests73312683_arrests
barrets94917103barre_ts
carets85330773c_are_ts
carnets93918403carne_ts
carpets113915333carpe_ts
carracks1637713carracks
carrells10359273carrells
carrels95117303carre_ls
carrots9714623carr_ots
cathects1545793cathects
cermets1139713cerme_ts
clarets94111103clare_ts
coacts105314333co__acts
coagents1138453coagents
cocreate122611813cocreate
cocreates132611883cocreates
codecs115112933co_dec_s
codirect13106293codirect_
coeffects1942463coeffects
coenacts1246403coenacts
coercers1237653coercers
coerces11311943coer_ces
coerected1447643coerected
coexerts1734883coexerts
coffrets1645363coffre_ts
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
corbeils12358073corbeils
corbels113813593corbe_ls
corders104520883corde_rs
corers85231073co_re_rs
cores76361853co_re__s
corkers134118853corke_rs
cormels113813373corme_ls
corneas94717003corne_as
corneitis1146493corneitis
cornels94716663corne_ls
corneous10310033corneous
corners94723313corne_rs
cornet84436733corne_t_
cornetcy1544303cornetcy
cornices12713293cornices
coronets103814363coronets
corrades111211263corrades
corrals93713853corr_als
correcting15199303correcting
correction1448813correction
corrections1548863corrections
corrective1747443corrective
correctives1845573correctives
correctness1553813correctness
correlate1149043correlate
correlates1248673correlates
corridas1177313corridas
corries94026803corr_ies
corrodes111310333corrodes
corrupt1149103corrupt_
corsacs1139013corsac_s
corselets1147313corselets
corses84433463corse__s
corset85636223corse_t_
corslets1038273corslets
corteges1198823corteges
cortexes1797613cortexes
cortices12615013cortices
corvees124613793corve_es
corves115122523corve__s
corvet114626933corve_t_
corvette1338093corvette
corvettes1447433corvettes
cosecs105015213co_sec_s
cosets85824403co_se_ts
cossets95014283cosse_ts
courants10310803courants
courts84216173cour__ts
coverts124813813co_verts
covets114819643co_ve_ts
crests85218703c__rests
crores86121163crore__s
cruets85314953c_rue_ts
curets84922343c_ure_ts
currachs1544543currachs
currants1037933currants
current9313693current_
curvets12399913curve_ts
directs102710263_directs
dornecks1543643dornecks
erects84116183__erects
ferrets103111393ferre_ts
forests104114953fo_rests
forfeits1445803forfeits
forgets113813793forge_ts
garrets84413623garre_ts
gorgets94711783gorge_ts
hornets104113553horne_ts
horrent10313553horrent_
incorrect1345373incorrect_
mordents1138813mordents
objects18123693_objects
orgeats838353_orgeats
orients7311583_orients
orrices9129363_orrices
perfects15107353perfects
portents103512823portents
projects1936413projects
prosects1239473prosects
protects1239743protects
reerects10319923reerects
sorbents10279133sorbents
sorbets93012513sorbe_ts
sorrels7310723sorre_ls
terrets72913583terre_ts
torments10310453torments
torrent7313413torrent_
turrets73010673turre_ts
worrits10258683worr_its
worsets105512843worse_ts

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 Limit1461621677.45319611.2
3Display Results1671670.0762197.4
 (SQL Overall)1786911677.95222471.2
 
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.