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

277 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
foodless1233838(None) 
footless113710801footless
fordless12289001fordless
hoodless12289731hoodless
woodless12278451woodless
bloodless1234512bloodless
bondless1148812bondless
boodlers113710742boodlers
boodles103416042boodle_s
boonless10328352boonless
bootless103410982bootless
broodless1235032broodless
cookless14258632cookless
cordless11299962cordless
doodlers10338842doodlers
doodles93614162doodle_s
doorless936712doorless
floorless1243792floorless
foamless13195842foamless
fogless1138192f_ogless
fondlers12338022fondlers
fondles113512612fondle_s
fondness1237212fondness
foodies113416752foodie_s
footlers113910792footlers
footles103715712footle_s
foozlers20346072foozlers
foozles19329542foozle_s
forkless15267432forkless
formless13248082formless
godless938402_godless
goodness1036252goodness
hoofless14258012hoofless
hookless151238362hookless
hoopless13279252hoopless
lordless9277482lordless
moonless10278042moonless
noodles83513192noodle_s
oodles73517182_oodle_s
poodles103013512poodle_s
roadless937702roadless
rodless8310072_rodless
roofless11316732roofless
rootless83910442rootless
toadless936312toadless
toolless836342toolless
wordless12258842wordless
aidless83612073_aidless
bedless1039703_bedless
bloomless1342963bloomless
blotless10347153blotless
bodiless1135913bodiless
boldness1136973boldness
boltless10338283boltless
boneless10310213boneless
boodies103721443boodie_s
boodle93215033boodle__
boodled113410933boodle_d
boodler103312003boodle_r
booklets14247123booklets
boomlets12246673boomlets
bootlegs11325873bootlegs
boundless1235183boundless
bowless123310313_bowless
browless1346653browless
budless1038873_budless
chadless1436403chadless
cloudless1243153cloudless
coalless1038193coalless
coatless1039693coatless
coddlers12359173coddlers
coddles114213593coddle_s
codeless112010113codeless
coldness1137953coldness
colorless1145683colorless
coolers93522493coo_lers
coolest9318643coo_lest
coolness1037743coolness
coreless103013833coreless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
deedless10318253deedless
doodies94218773doodie_s
doodle83212853doodle__
doodled10369463doodle_d
doodler93310153doodle_r
doolees83711613doo_lees
downless1236363downless
egoless836983ego_less
endless839833_endless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
fatless103212203f_atless
fearless1137873fearless
feckless17225783feckless
feeless103511103f_eeless
feetless1137383feetless
fernless1136063fernless
fiddlers13328283fiddlers
fiddles123212603fiddle_s
filmless1344553filmless
finless102810783f_inless
fireless112810593fireless
fishless1436413fishless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
flockless1843163flockless
flooders12257833flood_ers
flourless1243533flourless
flyless1335003f_lyless
focusless1452263focusless
fodders124010753f_odders
foibles1238853foible_s
folders113514393fold_ers
foleys123810463f_o_leys
folles93820473f_olle_s
fondest11312403fond_est
fondle104412943fondle__
fondled12399423fondle_d
fondler11348883fondle_r
fondues11399313fondue_s
foodie104413843foodie__
foods95924163food___s
foodways1844293foodways
fooled104317823foo_le_d
foolery1336693foo_lery
foolish1339613foo_lish
fools86824203foo_l__s
footers104618333foo_ters
footies103721543footie_s
footiest113514913footiest
footle93914383footle__
footled113610763footle_d
footler104011873footle_r
footlessly1663313footlessly
footrest11308853footrest
footrests12244503footrests
foozle18369203foozle__
foozled20346893foozle_d
foozler19397593foozle_r
forceless1435723forceless
fordoes11311963fordoe_s
forelegs1236613forelegs
fortress1136753fortress
foulest10313313f_oulest
foulness11236653foulness
fowlers133411203f_owlers
foxiness18257403foxiness
foziness20257803foziness
fretless1138063fretless
frockless1843453frockless
froglets1235263froglets
frontless1235403frontless
frostless1235743frostless
fuddles123611933fuddle_s
fumeless13236603fumeless
furless103210143f_urless
fuseless11237233fuseless
goalless935723goalless
goddess1035263_goddess
goodies93516993goodie_s
goodliest1146393goodliest
gormless11235443gormless
handless123512063handless
headless12289863headless
heedless12278813heedless
holeless1189363holeless
homeless131110133homeless
hondles113614523hondle_s
hoodies113419833hoodie_s
hoodiest122413173hoodiest
hoodlums1443273hoodlums
hooklets15217203hooklets
hopeless13118303hopeless
hornless1137363hornless
jobless16237563_jobless
joyless17226513_joyless
kindless13289243kindless
knotless1264563knotless
landless94011173landless
leadless9248793leadless
lidless8309273_lidless
loamless10235213loamless
loftless1135903loftless
lossless835473lossless
loudness937013loudness
loveless1168573loveless
mindless11319443mindless
moodiest112712183moodiest
moodiness12197593moodiness
mooleys1236863moo_leys
moonlets10247473moonlets
mootness1036753mootness
motorless1145723motorless
moveless1367753moveless
needless9308333needless
noddles92911293noddle_s
noodges9317703noodge_s
noodle73212543noodle__
noodled9339923noodle_d
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
oddness935313_oddness
odorless934173odorless
oldness836403_oldness
oodlins83210513_oodlins
orbless937493_orbless
plotless10256793plotless
poetless1038723poetless
poleless1089873poleless
poodle93112043poodle__
poolers94217423poo_lers
poorness1036363poorness
popeless1288473popeless
portless10310643portless
rindless92510193rindless
rockless14297293rockless
rootles73215633rootle_s
rootlets8308653rootlets
sandless93212343sandless
seedless9319513seedless
shoeless1137803shoeless
smogless1134053smogless
snowless1145623snowless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613_sonless
soulless8218763soulless
soundless1035533soundless
soupless10268463soupless
spotless1037043spotless
thowless1434613thowless
toddlers10346963toddlers
toddles93211533toddle_s
toeless72612393_toeless
tombless1236773tombless
toneless8610393toneless
toolers74416503too_lers
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
townless1135653townless
toyless10268713_toyless
voidness1235553voidness
voteless1137493voteless
vowless13246603_vowless
wardless12249303wardless
weedless12287963weedless
weldless12285813weldless
windless123310863windless
woodhens1534103woodhens
woodies113517153woodie_s
woodiest123112073woodiest
woodiness13147873woodiness
woodlots1245343woodlots
woolens10398843woo_lens
woolers104214023woo_lers
woollens1144093woollens
workless15276803workless
woundless1334033woundless
yodlers11298923_yodlers
yodles103714333_yodle_s
yokeless1535303yokeless
zoneless1737823zoneless
zoogleas1843373zoogleas

Search took 10 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 Limit1461622778.76616673.7
3Display Results2772770.1102518.2
 (SQL Overall)1786912779.03219784.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.