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

242 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
foamless1319584(None) 
formless13248081formless
loamless10235211loamless
beamless12327002beamless
coalless1038192coalless
coatless1039692coatless
fameless13259202f_ameless
fatless103212202f_atless
fearless1137872fearless
filmless1344552filmless
flagless1235402flagless
flameless1435352flameless
flapless1335342flapless
flawless1434502flawless
foamers123812102foam_ers
foamiest13289852foamiest
foaminess1437502foaminess
fogless1138192fo_gless
foodless12338382foodless
footless113710802footless
fordless12289002fordless
forkless15267432forkless
frameless1435532frameless
goalless935722goalless
gormless11235442gormless
normless10235922normless
oarless73913372_oarless
roadless937702roadless
seamless10238722seamless
soapless10278072soapless
toadless936312toadless
tramless1037502tramless
aimless93610813_aimless
armless9369943_armless
awless939263__awless
barless94317003_barless
beakless14297383beakless
beatless103311593beatless
blameless1334733blameless
bloomless1342963bloomless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boomlets12246673boomlets
boonless10328353boonless
bootless103410983bootless
bowless123310313bo_wless
braless92910563bra_less
brimless1235273brimless
camlets114314623_camlets
capless114312763_capless
carless95118493_carless
chadless1436403chadless
charmless1633583charmless
clawless1334123clawless
coalers94419353coa_lers
codeless112010113codeless
cookless14258633cookless
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coxless1637743co_xless
doorless936713doorless
downless1236363downless
dreamless1243513dreamless
earless74316073_earless
fablers124812613f_ablers
fables114921673f_able_s
faceless13269173faceless
fadeless12258323fadeless
fallers103917993f_allers
fames105735923f_am_e_s
fangless1237663fangless
farles96025783f_arle_s
farness102912203f_arness
fatness103311293f_atness
feastless1235043feastless
feckless17225783feckless
feeless103511103f_eeless
feetless1137383feetless
females12310663female_s
fernless1136063fernless
finless102810783f_inless
fireless112810593fireless
firmness1334743firmness
fishless1436413fishless
flambes14419503flambe_s
flamens124611063flam_ens
flamers124616363flam_ers
flames114723693flam_e_s
flamiest133111983flamiest
flatlets1147373flatlets
flatness1138153flatness
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
flyless1335003f_lyless
foaled104515963foa_le_d
foals85721693foa_l__s
foamed126014403foam_e_d
foamer114714313foam_e_r
foamier12339003foamie_r
foamlike1735143foamlike
foams105017953foam___s
focusless1452263focusless
foibles1238853foible_s
foleys123810463fo__leys
folles93820473fo_lle_s
fondlers12338023fondlers
fondles113512613fondle_s
fondness1237213fondness
footlers113910793footlers
footles103715713footle_s
foozlers20346073foozlers
foozles19329543foozle_s
foramens1337823foram_ens
forceless1435723forceless
forelegs1236613forelegs
formalness1544833formalness
formers128217953form_ers
formes114623713form_e_s
formlessly1842953formlessly
fortress1136753fortress
foulest10313313fo_ulest
foulness11236653foulness
fowlers133411203fo_wlers
foxiness18257403foxiness
foziness20257803foziness
frailest1139493frailest
frailness1236543frailness
framers125113823fram_ers
frames115119863fram_e_s
fretless1138063fretless
frockless1843453frockless
frontless1235403frontless
frostless1235743frostless
fumeless13236603fumeless
furless103210143f_urless
fuseless11237233fuseless
gapless10349993_gapless
gasless8319013_gasless
gearless937373gearless
godless938403go_dless
gumless10228273_gumless
hamlets123211403_hamlets
hapless123311333_hapless
harmless1337403harmless
hatless103813443_hatless
headless12289863headless
heatless113011463heatless
helmless1334273helmless
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
jagless1537103_jagless
jawless1745653_jawless
jobless16237563jo_bless
joyless17226513jo_yless
lawless1037033_lawless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
loamiest102310213loamiest
loaminess1137493loaminess
loftless1135903loftless
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
manless93012933_manless
matless93014043_matless
mealless10288363mealless
meatless103410863meatless
moonless10278043moonless
moveless1367753moveless
nameless10248373_nameless
napless93110283_napless
noseless839513noseless
noteless839403noteless
nounless837253nounless
orbless937493_orbless
peakless14236683peakless
planless1036813planless
playless1334863playless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
portless10310643portless
rayless10239003_rayless
rimless9369363_rimless
roamers93713463roam_ers
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
samlets93813553_samlets
sapless93313443_sapless
scarless10189053scarless
scumless1254993scumless
seatless83213003seatless
shameless1435923shameless
snapless10287463snapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613so_nless
soulless8218763soulless
soupless10268463soupless
spanless10247363spanless
stampless1334543stampless
starless81610843starless
stemless1036653stemless
sumless92611123_sumless
tameless10259903_tameless
taxless1436913_taxless
tearless848713tearless
termless1036233termless
thawless1434083thawless
toeless72612393to_eless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
voteless1137493voteless
vowless13246603vo_wless
warless104015103_warless
wayless13308243_wayless
womanless1443383womanless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
yokeless1535303yokeless
zoneless1737823zoneless

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622427.11020557.2
3Display Results2422420.1102200.0
 (SQL Overall)1786912427.65623340.0
 
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.