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

233 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
townless113565(None) 
downless1236361downless
townlets1134771townlets
awnless1035922_awnless
boonless10328352boonless
bowless123310312bow_less
crownless1443422crownless
hornless1137362hornless
lowness1037812lown_ess
moonless10278042moonless
nounless837252nounless
nowness1037032nown_ess
sonless72612612so_nless
thornless1243632thornless
thowless1434612thow_less
toadless936312toadless
toeless72612392to_eless
tombless1236782tombless
toneless8610392toneless
tonlets73212502to_nlets
toolless836342toolless
topless92511122to_pless
townees10269782town_ees
townies103113622townie_s
townlet1049732townle_t
toyless10268712to_yless
vowless13246602vow_less
aweless1038723_aweless
awless939263_aw_less
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
bootless103410983bootless
boundless1235183boundless
bowelless1443833bowelless
bowlegs13366823bow_legs
bowlers123715783bow_lers
browless1346653brow_less
brownness1444343brownness
chinless1337493chinless
coalless1038193coalless
coatless1039693coatless
codeless112010113codeless
confess12399903co_nfess
cookless14258633cookless
coolness1037743coolness
cordless11299963cordless
coreless103013833coreless
costless10310003costless
countess103710053countess
countless1146373countless
coxless1637743co_xless
coyness1277323coyn_ess
dewless1137473dew_less
doorless936713doorless
dowerless1344013dowerless
downers113912773down_ers
downiest122710603downiest
downiness13106713downiness
fernless1136063fernless
fewness1335003fewn_ess
finless102810783_finless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulness11236653foulness
fowlers133411203fow_lers
gainless9117403gainless
goalless935723goalless
godless938403go_dless
gormless11235443gormless
gunless8299633_gunless
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hotness1038613hotn_ess
howlers133312353how_lers
howlets13329223how_lets
hymnless1632803hymnless
innless7288293_innless
jawless1745653jaw_less
jobless16237563jo_bless
jointless1634323jointless
joyless17226513jo_yless
kinless113310273_kinless
lawless1037033law_less
loamless10235213loamless
loftless1135903loftless
lordless9277483lordless
lornness836493lornness
lossless835473lossless
loveless1168573loveless
manless93012933_manless
moonlets10247473moonlets
moveless1367753moveless
newness1035703newn_ess
newsless1134533newsless
normless10235923normless
noseless839513noseless
noteless839403noteless
oarless73913373_oarless
orbless937493_orbless
owlets93110393_ow_lets
owners94210703_own_ers
painless10108343painless
planless1036813planless
poetless1038723poetless
pointless1135703pointless
poleless1089873poleless
popeless1288473popeless
portless10310643portless
powerless1444293powerless
rainless8129703rainless
rawness1038153rawn_ess
reinless8139433reinless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
runless72810423_runless
sinless73014213_sinless
skinless12216973skinless
slowness1135013slown_ess
snowless1145633snow_less
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
soulless8218763soulless
soundless1035533soundless
soupless10268463soupless
spanless10247363spanless
spinless10238703spinless
stainless9176493stainless
sunless73013693_sunless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
taintless935733taintless
tallness837103tallness
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tawneys13324773tawn_eys
tawnies102812503tawnie_s
tawniest11279343tawniest
tawniness1245123tawniness
taxless1436913t_axless
tearless848713tearless
tentless8229843tentless
termless1036233termless
textless15245793textless
thankless1633203thankless
thawless1434083thawless
thewless1433923thewless
thinness11277163thinness
tideless9269083tideless
tieless72512563t_ieless
timeless10239543timeless
tintless8239863tintless
tipless92610063t_ipless
tireless82510263tireless
toddlers10346963toddlers
toddles93211533toddle_s
togglers10276953togglers
toggles93710973toggle_s
toilers74116263to_ilers
toiles63923513to_ile_s
toilets74112913to_ilets
toles55147133to__le_s
tollers73217463to_llers
toners64128003to_n_ers
tones56048663to_n_e_s
tongers84116013to_ngers
toniest73218903to_niest
tonlet62924703to_nle_t
tonners73816403to_nners
tonnes65320853to_nne_s
tonuses73612193to_nuses
toolers74416503to_olers
toonies73719883toonie_s
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topples113111653topple_s
tousles74113933tousle_s
touzles16359223touzle_s
towages1139233towage_s
toweled112410223towele_d
towels94314643tow__els
towers94423673tow__ers
towhees13277793tow_hees
towies93521193tow_ie_s
townee92815213town_e_e
townie93312303townie__
townish13167933town_ish
towns86018883town___s
townwear1442293townwear
tramless1037503tramless
treeless839283treeless
trowelers12105263trowelers
tubeless1037023tubeless
tugless837383t_ugless
tuneless837913tuneless
turfless1135533turfless
tuskless1234213tuskless
twigless1293663twigless
unless62413073__unless
veinless11136263veinless
voteless1137493voteless
winless103212283_winless
woeness1020211543woen_ess
womanless1443383womanless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
wornness1136363wornness
woundless1334033woundless
yokeless1535303yokeless
yowlers13328923yow_lers
zoneless1737823zoneless

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.423422437.4
2DLD Change Limit1461622336.29623215.1
3Display Results2332330.0932505.4
 (SQL Overall)1786912336.81226231.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.