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

213 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
correct1151398(None) 
coerect11913351coerect
corrects1259571corrects
porrect1159741porrect
codirect13106292codirect
coerects1258542coerects
collect113314592collect
confect143614272confect
connect113515742connect
convect143114482convect
cornet84436732corne_t
corrected1438122corrected
correcter1348112correcter
correctly1644962correctly
corrector1347602corrector
corrupt1149102corrupt
corset85636222corse_t
corvet114626932corve_t
current9313692current
horrent10313552horrent
incorrect1345372incorrect
torrent7313412torrent
acrolect1247423acrolect
arrest63722633_arrest
barret84930493barre_t
caret75360563c_are_t
carnet84732873carne_t
carpet104530093carpe_t
carrack1548753carrack
carrel84718633carre_l
carrell94610473carrell
carrels95117303carrels
carroch1437093carroch
carrot8423123carr_ot
cathect1439863cathect
cermet10321153cerme_t
claret84026573clare_t
coact96130583co__act
coagent10313983coagent
coarsest1039163coarsest
cocreate122611813cocreate
codec107120343co_dec_
codecs115112933co_decs
codirects1493593codirects
coeffect1843933coeffect
coenact11311803coenact
coerce10310403coer_ce
coerced1238583coerced
coercer1138383coercer
coerces11311943coerces
coerected1447643coerected
coexert16312363coexert
coffret15310073coffre_t
cogent9321003co_gent
coherent13412473coherent
coinfect15276843coinfect
coldest102514763coldest
collects12279783collects
collet84030363colle_t
comet95946073co_me_t
comment1310317703comment
compact153712213compact
complect1659013complect
conceit113218073conceit
concent114422513concent
concept133314443concept
concert113325223concert
concoct10312903concoct
conduct121411593conduct
confects153110873confects
congest104618773congest
connects123010563connects
consent93723113consent
contact1144020683contact
content94326153content
contest93523233contest
context163913433context
contract122915633contract
convects153410993convects
convent123919413convent
convert123721473convert
convict143410983convict
coolest9318643coolest
coparent12412253coparent
copeck1636943co_peck
coquet174318013coque_t
corbeil11859213corbeil
corbel103715973corbe_l
corbels113813593corbels
corded105923353corde_d
corder94322883corde_r
corders104520883corders
core67263113co_re__
cored85044223co_re_d
corer75538873co_re_r
corers85231073co_rers
cores76361853co_re_s
corked135020783corke_d
corker124720853corke_r
corkers134118853corkers
corkiest143114793corkiest
cormel103815603corme_l
cormels113813373cormels
cornea84018933corne_a
corneal94414503corneal
corneas94717003corneas
corned95224523corne_d
cornel84020053corne_l
cornels94716663cornels
corner84625623corne_r
corners94723313corners
cornetcy1544303cornetcy
cornets94820573cornets
cornice11612933cornice
corniest102117303corniest
coronet94227173coronet
corrade101111043corrade
corral83616253corr_al
corrals93713853corrals
correctest1445613correctest
correcting15199303correcting
correction1448813correction
corrective1747443corrective
correctors1447503correctors
correlate1149043correlate
corrida1078523corrida
corrie83621233corr_ie
corries94026803corries
corrode101310573corrode
corrody13136143corrody
corrupts1244983corrupts
corsac10410173corsac_
corsacs1139013corsacs
corse75036183corse__
corselet10414573corselet
corses84433463corse_s
corsets94819803corsets
corslet9318063corslet
cortege1098953cortege
cortex15311473corte_x
corvee114320093corve_e
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
corvette1338093corvette
cosec96320183co_sec_
cosecs105015213co_secs
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
courant9317973courant
court75532773cour__t
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
coyest11316053co_yest
coziest184014353coziest
crept95125893c__rept
crest74632693c__rest
crore74922873crore__
crores86121163crore_s
cruet74831843c_rue_t
curet75447643c_ure_t
currach1446453currach
currant9314173currant
curred94319263curre_d
currency1545543currency
currents1038373currents
curtest9713963curtest
curvet114720243curve_t
direct93817333_direct
dorneck1444303dorneck
dourest8312943dourest
erect74129333__erect
ferret93021173ferre_t
forest94926743fo_rest
forfeit1339203forfeit
forget106326393forge_t
fornent10312933fornent
forrit91916623forr_it
forwent13310533forwent
garret74426563garre_t
gorget87123863gorge_t
goriest82218743goriest
hornet94926433horne_t
mordent10313993mordent
object17135803_object
obtect10129633_obtect
orgeat7515033_orgeat
orient6322533_orient
orrery936783_orrery
orrice81410163_orrice
perfect141010833perfect
poorest9312773poorest
portent93619643portent
project1838453project
prosect11313393prosect
protect11313633protect
reerect92915883reerect
sorbent92915243sorbent
sorbet83924083sorbe_t
sorest65028003so_rest
sorrel6413553sorre_l
sorrels7310723sorrels
sorriest8413883sorriest
sourest7515713sourest
terret63425623terre_t
torment9316173torment
torrefy1353353torrefy
torrents838143torrents
turret63121853turre_t
worrit92313313worr_it
worset96726583worse_t

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.436409841.7
2DLD Change Limit1340272137.31318327.2
3Display Results2132130.0762802.6
 (SQL Overall)1786912137.82522835.9
 
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.