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

157 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
curetting123657(None) 
curvetting1643391curvetting
creating113921952c_reating
cresting114017042c_resting
curating11314292cur_ating
curveting1535352curveting
cutting103817492cu__tting
duetting1047182du_etting
fretting122711522_fretting
retting83425882__retting
abetting1158293_abetting
accreting1446333accre_ting
arresting1038633arresting
aureoling1045873aureoling
befretting1644793befretting
begetting13186583begetting
besetting12268423besetting
betting103921403__betting
bursting1138703bur_sting
butting103519283bu__tting
carburetting1751823carburetting
careening12310013careening
careering12311203careering
caressing1238803caressing
caretaking1765333caretaking
carpeting1439483carpeting
carting104228283car__ting
caseating12311743caseating
catting103922643c__atting
caveating1539293caveating
cementing1438763cementing
chatting142810143c_hatting
cheating144014523c_heating
cleating113518133c_leating
clefting14347583c_lefting
clotting113110643c_lotting
cocreating15310293cocreating
coerecting15218783coerecting
coquetting2244513coquetting
corelating13511583corelating
corotating1349323corotating
correcting15199303correcting
corseting12312173corseting
courting112514573cour__ting
coveting141912303cove_ting
crafting143710173c_rafting
crating103725203c_r_ating
creaking153414123c_reaking
creaming133413143c_reaming
creasing113314443c_reasing
creatin93618133c_reatin_
creatine103417413c_reatine
creatins103617513c_reatins
crediting1338843c_rediting
creeling113513363c_reeling
creeping133310103c_reeping
cremating14312193c_remating
creping122913653c_re_ping
crestings12298043c_restings
cretin82917913c_re_tin_
cretins93216423c_re_tins
crewing133212623c_re_wing
crusting113612793c_rusting
cueing94913613cu_e__ing
cuittling1234103cuittling
cupeling1338863cupe_ling
cupelling1436283cupelling
curbing123814023cur__bing
curding113515133cur__ding
curdling12228893cur_dling
curettage1242353curettage
curette939783curett__e
curetted1137173curett_ed
curettes1039313curett_es
curing94824783cur___ing
curling104320183cur__ling
curring103616843cur__ring
currying14196493cur_rying
cursing104217033cur__sing
curtain9319793cur_tain_
curtains10259703cur_tains
curtsying1543813curtsying
curving133912103cur__ving
cuttings11277613cu__ttings
cuttling1138203cu_ttling
deratting1139513deratting
directing1338813directing
dratting10389653_dratting
dueting93814393du_e_ting
erecting112415063_erecting
facetting1535283facetting
fetting113517873__fetting
foresting13311363foresting
forgetting1544663forgetting
fritting123510703_fritting
furcating1537783furcating
garotting1136103garotting
gazetting2043243gazetting
getting93316563__getting
greeting103112353_greeting
gritting10309983_gritting
guesting1058463gu_esting
gutting93415923gu__tting
hurting113914033hur__ting
hurtling12318313hur_tling
hutting113016033hu__tting
inletting1087873inletting
insetting1079283insetting
jetting153815343__jetting
jutting153313713ju__tting
laureating1146393laureating
letting83218533__letting
netting84018763__netting
nutting83316233nu__tting
outeating10814493outeating
parenting12611583parenting
pargetting1444943pargetting
petting103720953__petting
pipetting1435513pipetting
prettying1536043_prettying
pureeing1137273pure_eing
putting103218573pu__tting
questing1838273qu_esting
quieting18228463quie_ting
quitting18228833qu_itting
ratting83822363__ratting
regretting1237783regretting
reletting102713943reletting
renting84026853__renting
rerenting102617663rerenting
resetting102816293resetting
resting85031183__resting
retying113213833__retying
revetting132912633revetting
rewetting132710443rewetting
rivetting13256413rivetting
rotting82919683__rotting
rouletting1144753rouletting
russetting1184253russetting
rutting82718043__rutting
setting83621393__setting
stetting93410713_stetting
strutting1037003strutting
subletting1346273subletting
surfeiting1445023surfeiting
threating131010043threating
treating92519613_treating
trotting92510913_trotting
turtling9238833tur_tling
tutting83515913tu__tting
unresting10311133unresting
unsetting1088993unsetting
upsetting1275563upsetting
vetting114216563__vetting
wetting114117383__wetting
whetting1535973_whetting
wresting123811833_wresting

Search took 7 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411576.68622231.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.90525878.5
 
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.