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

180 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
coattest103886(None) 
coattests1143461coattests
attest62618612__attest
cattiest103016332c_attiest
chastest1349702chastest
chattiest1448202chattiest
coaliest10316222coaliest
coarsest1039162coarsest
coatees93816552coatees_
coatless1039692coatless
coattend1134652coattend
coattested1342972coattested
contest93523232co_ntest
couthest13312082couthest
fattest102913062_fattest
flattest1138712flattest
hottest10411382ho_ttest
phattest1336912phattest
posttest10410232posttest
wattest102412152_wattest
aptest82917513__aptest
attent62818323__attent
attests7278813__attests
battiest104115553_battiest
brattiest1148103brattiest
cagiest102916433c_agiest
cakiest133215663c_akiest
calmest11312343c_almest
cartes86239473c_artes_
castes85631863c_astes_
cates75951893c_a_tes_
cathect1439863c_athect
catted95422473c_atte_d
cattery123811603c_attery
catties94023053c_atties_
cattish12410723c_attish
chariest13315503chariest
chartist131112133chartist
chatted133411893chatte_d
chattel12388893chatte_l
chattels13286793chattels
chatter124416643chatte_r
chatters134213953chatters
chattery16357273chattery
clatter94014973clatte_r
clatters103313913clatters
clattery13378193clattery
clayiest1337913clayiest
coaches144018693coaches_
coacted123611613coacte_d
coacts105314333coact_s_
coagent10313983coa_gent
coalless1038193coalless
coapted123911503coapte_d
coapts104614013coapt_s_
coassist10298803coassist
coast75236273coa___st
coasted104015953coaste_d
coaster94219043coaste_r
coasters104317333coasters
coasts85719143coast_s_
coatdress1243193coatdress
coated94927043coa_te_d
coatee84327223coa_te_e
coater84329573coa_te_r
coaters93525793coa_ters
coatis85122603coa_tis_
coats75635003coa_t_s_
coattail1045313coattail
coattends1243913coattends
coattesting1443453coattesting
coaxes154715633coa_xes_
cobbiest14118523cobbiest
cockiest163013293cockiest
cocottes1238303cocottes_
coldest102514763co_ldest
comates114123643comates_
comfiest1539133comfiest
compactest1845043compactest
comtes106222813co_mtes_
congest104618773co_ngest
conquest1939553conquest
content94326153co_ntent
contes84432913co_ntes_
contests103413383co_ntests
context163913433co_ntext
contrast102614783contrast
coolest9318643co_olest
cooties93725733cooties_
corkiest143114793corkiest
corniest102117303corniest
cosiest93819853co_siest
costless10310003costless
costliest1138563costliest
cotes76347843co__tes_
cottas84615573co_ttas_
cotter84926673co_tte_r
cotters94323443co_tters
couldest1148353couldest
countess103710053countess
courtesy1364973courtesy
couthiest1439403couthiest
cowiest123614673co_wiest
coyest11316053co__yest
coyotes12410703coyotes_
coziest184014353co_ziest
craftiest1436913craftiest
crankest1438143crankest
crassest103411523crassest
crates85736063cra_tes_
craziest19319923craziest
croakiest15167173croakiest
curtest9713963c_urtest
cutest85820143c__utest
daftest11248943_daftest
dotiest83717453do_tiest
dottiest92611393dottiest
exactest1745453exactest
fastest102413723_fastest
fattiest113514313_fattiest
featest102715113fea_test
fittest102510803_fittest
floatiest1237283floatiest
foamiest13289853foamiest
footiest113514913footiest
footrest11308853footrest
gnattiest1035383gnattiest
goatees82710443goatees_
goutiest93013883goutiest
hoariest11312883hoariest
hoarsest1137133hoarsest
hootiest113115643hootiest
iratest7312483ira_test
joltiest15249403joltiest
latest63822703_la_test
lattes65324203_lattes_
loamiest102310203loamiest
loathes103513243loathes_
loftiest1139083loftiest
lottes65322753lo_ttes_
matiest92522453_matiest
mattes85624533_mattes_
meatiest102816793meatiest
moistest1038763moistest
mostest9314793mo_stest
mottes85523693mo_ttes_
nattiest83215353_nattiest
neatest72516003nea_test
notates72817483notates_
oakiest112913923_oakiest
obtest81213013_o_btest
oftest91212003_o_ftest
peartest10311303peartest
peatiest103118803peatiest
platiest103216083platiest
politest10312943politest
posttests1144973posttests
pottiest102815973pottiest
poutiest103016793poutiest
rattiest83516113_rattiest
rootiest83115593rootiest
rotates72819773rotates_
rottes64524833ro_ttes_
saltest71916513_saltest
scantest101710183scantest
scattiest11268363scattiest
slatiest82616263slatiest
smartest10310183smartest
soapiest102412843soapiest
softest10310603so_ftest
soothest113312243soothest
sootiest84016753sootiest
squattest1844613squattest
tartest72517533_tartest
tattiest83415383_tattiest
tautest72612443_tautest
toastiest937423toastiest
vastest102911513_vastest
wettest10239363_wettest
zootiest173311213zootiest

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621806.65621959.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.87525991.4
 
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.