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

162 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
curtail929966(None) 
curtails10318241curtails
curtain9319791curtain
curtal83914541curta_l
cattail939182cattail
certain92612212certain
curial84019152curia_l
curtailed1244112curtailed
curtailer1143822curtailer
curtains10259702curtains
curtals93111622curtals
curtate9312642curtate
airmail946213airmail
aortal65217513aorta_l
artal55525473_arta_l
aural54428963aur_a_l
bobtail1146553bobtail
brail75525553_br_ail
brutal859383bruta_l
bucktail1653913bucktail
burial84117623buria_l
bursal84414823bursa_l
camail10314833c_amail
cantal84122033canta_l
captain112111063captain
carnal83919203carna_l
carpal103716253carpa_l
cartable121314093cartable
cartage10312593cartage
cartel85022533cart_el
cattails1038553cattails
centai84814783centai_
cental84420963centa_l
ceratin93020163ceratin
cercal10314123cerca_l
cereal8315833cerea_l
certainly1443153certainly
chital114313883chita_l
citral81113893citra_l
coattail1045313coattail
cocktail1645363cocktail
coital84117053coita_l
contain9315833contain
contrail10410983contrail
coral76033453cor_a_l
corbeil11859213corbeil
cordial10312943cordial
corral83616253corra_l
corsair937633corsair
cortin82423153cort_in
costal85419513costa_l
craal74117753c_r_aal
crawl104916713c_r_awl
crucial1157893crucial
crural8610633crura_l
crustal939023crusta_l
cubital1137103cubita_l
culti76317253cult_i_
cultic105111903cult_ic
cuneal8611513cunea_l
curable112414513cur_able
curably142010773cur_ably
curacy1339593cur_acy
curagh1236553cur_agh
curara83712203cur_ara
curare84916953cur_are
curari84414403cur_ari
curaris94114773curaris
curate85226243cur_ate
curated104717583curated
curates95323833curates
curating11314293curating
curative13310403curative
curator9312213curator
curbable1447663curbable
curia74523773cur__ia
curiae84518373curia_e
curie74533043cur__ie
curio74221213cur__io
curl66035053cur___l
curlily1238383cur_lily
currach1446453currach
curragh1344293curragh
curran8312023curra_n
currans9310613currans
currant9314173currant
currie84317263cur_rie
curt67051713curt___
curtailers1243403curtailers
curtailing1344603curtailing
curtained1265503curtained
curtalax1742053curtalax
curter85320083curt_er
curtest9713963curtest
curtesy1265833curtesy
curtly1149283curt_ly
curtsey1255013curtsey
curtsied1134953curtsied
curtsies1038733curtsies
curtsy1156643curt_sy
cuspal1037883cuspa_l
custard10389973custard
cutie76925933cu_t_ie
cutin75022783cu_t_in
cutis77723763cu_t_is
cuttable1247953cuttable
cuttage10318343cuttage
derail74218813der_ail
detail74516433_detail
drail65020973_dr_ail
ducktail1542913ducktail
ductal938993ducta_l
dural64923893dur_a_l
entail61114343_entail
fantail10310233fantail
foxtail1745383foxtail
frail85220213_fr_ail
grail64622873_gr_ail
hartal9415473harta_l
horntail11105033horntail
hurtful1344853hurtful
jural125120483jur_a_l
kurta95113913kurta__
kurtas10349883kurta_s
lugsail843443lugsail
martial92415413martial
mortal84616853morta_l
mural75225113mur_a_l
murrain937763murrain
nuptial946633nuptial
outsail71411413outsail
oxtail1337653_oxtail
partial92616263partial
pertain92714963pertain
pigtail1046623pigtail
pintail9311183pintail
portal84218463porta_l
quail144314363qu__ail
rail46147763__r_ail
rattail737803rattail
redtail858713redtail
retail65522073_retail
rural55821173rur_a_l
scurril945113scur_ril
serail64222673ser_ail
sural55931263sur_a_l
surtax1337843surta_x
surveil1045093surveil
sustain738773sustain
tail45443653___tail
tertial7313863tertial
trail55126773_tr_ail
turmoil944723turmoil
unnail6410583_unnail
until53517743_unt_il
uracil8311543_uracil
uratic83016353_uratic
ureal56722683_urea_l
urial54823023_uria_l
ventail10310453ventail
wagtail1145043wagtail
yurta86014253yurta__

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 Filter1786911340270.593301333.9
2DLD Change Limit1340271626.18621666.2
3Display Results1621620.0463521.7
 (SQL Overall)1786911626.82526181.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.