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

206 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
curtain931979(None) 
certain92612211certain
curtail9299661curtail
curtains10259701curtains
captain112111062captain
ceratin93020162ceratin
contain9315832contain
cortin82423152cort_in
curating11314292curating
curran8312022curra_n
curtails10318242curtails
curtained1265502curtained
curtal83914542curta_l
curtals93111622curtals
curtate9312642curtate
cutin75022782cu_t_in
murrain937762murrain
pertain92714962pertain
sustain738772sustain
abstain947253abstain
ascertain1144233ascertain
attain6311753_attain
bargain1079063bargain
brain76229383_br_ain
buran75225303bur_a_n
burin75626063bur__in
burthen1236363burthen
burton8311273burt_on
caftan111710123cafta_n
cain65643913c___ain
calpain11310413calpain
captains121810573captains
captan101613343capta_n
carabin11313213carabin
carbarn1139453carbarn
carlin84421823car_lin
carman103920743carma_n
carotin92216733carotin
cartage10312593cartage
carting104228283cart_ing
carton84522663cart_on
cartoon94114463cartoon
catkin123512383c_atkin
catlin83819083c_atlin
cattail939183cattail
centai84814783centai_
ceratins102818733ceratins
certainer1146193certainer
certainly1443153certainly
certainty1443193certainty
chain105723673c__hain
chitin113114963chit_in
chitlin12269283chitlin
citrin82615413c_itrin
cocain101315013c_ocain
contains10316533contains
corban10314693corba_n
cordwain1444413cordwain
corsair937633corsair
cortina91915973cort_ina
cortins92421333cort_ins
cotan71521783c_ota_n
countian1048123countian
courlan9117763courla_n
courting112514573court_ing
crating103725203c_rating
craton84517193c_raton
creatin93618133c_reatin
cretin82917913c_retin
crucian1146283crucian
culti76317253cult_i_
cultic105111903cult_ic
cumarin1139263cumarin
cumin94616973cu__min
cummin1288783cu_mmin
curacy1339593cur_acy
curagh1236553cur_agh
curara83712203cur_ara
curare84916953cur_are
curari84414403cur_ari
curarine10610713curarine
curaris94114773curaris
curate85226243cur_ate
curated104717583curated
curates95323833curates
curative13310403curative
curator9312213curator
curbing123814023cur_bing
curding113515133cur_ding
curdling12228893curdling
curetting1236573curetting
curia74523773cur__ia
curiae84518373curia_e
curial84019153curia_l
curie74533043cur__ie
curing94824783cur__ing
curio74221213cur__io
curling104320183cur_ling
curn66731893cur___n
currach1446453currach
curragh1344293curragh
currans9310613currans
currant9314173currant
currie84317263cur_rie
curring103616843cur_ring
currying14196493currying
cursing104217033cur_sing
curt67051713curt___
curtailed1244113curtailed
curtailer1143823curtailer
curtailing1344603curtailing
curtaining1345533curtaining
curtalax1742053curtalax
curter85320083curt_er
curtest9713963curtest
curtesy1265833curtesy
curtly1149283curt_ly
curtsey1255013curtsey
curtsied1134953curtsied
curtsies1038733curtsies
curtsy1156643curt_sy
curtsying1543813curtsying
curving133912103cur_ving
custard10389973custard
cutie76925933cu_t_ie
cutins83919983cu_t_ins
cutis77723763cu_t_is
cutline92914543cu_tline
cuttage10318343cuttage
cutting103817493cu_tting
cuttling1138203cuttling
cystein1246053cystein
destain8412083destain
detain74617383_detain
detrain8412253detrain
distain8313783distain
drain65222893_dr_ain
duration9312693duration
durian7312003duria_n
dustbin1044543dustbin
entrain7313073entrain
fountain1144923fountain
furan84320013fur_a_n
fusain958643fu_sain
fustian1036903fustian
grain65126253_gr_ain
gratin74520583_gratin
hurting113914033hurt_ing
hurtling12318313hurtling
keratin113314153keratin
kurgan11126783kurga_n
kurta95113913kurta__
kurtas10349883kurta_s
lurdan738363lurda_n
lutein6311263lu_tein
martian93514683martian
martin84122523mart_in
mortmain1244573mortmain
mountain1046113mountain
muntin82915183munt_in
murein8311763mur_ein
murrains1036853murrains
obtain839183_obtain
ordain7810403_ordain
ouabain944943ouabain
outgain81010743outgain
outlain71212613outlain
outran63218893outra_n
outsin63617563ou_tsin
partan83820563parta_n
pertains102113423pertains
purin75527593pur__in
puritan939283purita_n
purlin83615863pur_lin
purloin9107493purloin
quartan1636423quarta_n
quatrain1745823quatrain
quintain17316223quintain
rain46251733__r_ain
retain64523283_retain
retrain7615423retrain
rurban849043rurba_n
rutin55421343ru_t_in
sextain14257103sextain
sprain83614863spr_ain
stain55727943__stain
strain64919573str_ain
sultan63012593sulta_n
suntan62613003sunta_n
surtax1337843surta_x
surtaxing1784143surtaxing
sustains838553sustains
tain45548073___tain
tartan64217513tarta_n
terrain7410853terrain
tertian7511193tertian
train56529113_tr_ain
turban8310483turba_n
turtling9238833turtling
uncertain1146203uncertain
uratic83016363_uratic
urban72013863_urba_n
urchin1138743_urchin
vervain1335563vervain
vitrain1038943vitrain
yurta86014253yurta__

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.390458182.1
2DLD Change Limit1340272066.83019623.3
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.30024478.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.