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

261 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
spotless103704(None) 
spoutless1134241spoutless
blotless10347152blotless
bootless103410982bootless
footless113710802footless
knotless1264572knotless
plotless10256792plotless
poetless1038722_poetless
portless10310642_portless
rootless83910442rootless
saltless8259342saltless
seatless83213002seatless
shitless11249242shitless
shoeless1137802shoeless
slitless8268142slitless
smogless1134052smogless
snowless1145632snowless
sonless72612612s_onless
spanless10247362spanless
spinless10238702spinless
spoilers10238632spoilers
spoolers10349362spoolers
spotlessly1543142spotlessly
spotters104313382spotters
apostles1037753apostle_s
apothems1544223apothems
aptness9268573ap_tness
artless73712513_artless
assetless943573assetless
beatless103311593beatless
beltless10297713beltless
boltless10338283boltless
boonless10328353boonless
bootlegs11325873bootlegs
bowless123310313_bowless
browless1346653browless
coatless1039693coatless
cookless14258633cookless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
debtless1135653debtless
doorless936713doorless
ductless11196313ductless
dustless9328353dustless
egoless836983ego_less
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
fogless1138193_fogless
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
fretless1138063fretless
frontless1235403frontless
frostless1235743frostless
giftless1245173giftless
godless938403_godless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hotness1038613_hotness
hurtless11307783hurtless
jobless16237563_jobless
joyless17226513_joyless
lintless82710013lintless
listless8269263listless
loftless1135903loftless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
moonless10278043moonless
mootness1036753mootness
motleys1235683_motleys
netless739863_netless
noteless839403_noteless
odorless934173odorless
pastless102411203pastless
pathless13138043_pathless
patness92912283_patness
pegless1038053_pegless
peltless10267373peltless
pilotless1143993pilotless
pithless13117023_pithless
pitiless10127333_pitiless
poetess938933_poetess
pointless1135703_pointless
poleis86018353_po_leis
poleless1089873_poleless
polers84225643_po_lers
poles75351003_po_le_s
pollees93215333_pollees
pollens93713303_pollens
pollers93420023_pollers
poolers94217423_poolers
popeless1288473_popeless
portress1038323_portress
possess9419123_possess
poteens92910883_poteens
pothers123818623_pothers
potters94024343_potters
pottles93816983_pottle_s
potzers184010543_potzers
restless82713163restless
riftless1136943riftless
rodless8310073_rodless
roofless11316733roofless
rootles73215633rootle_s
rootlets8308653rootlets
rustless83510243rustless
sailless82410373sailless
saltness82610243saltness
sandless93212343sandless
sapless93313443s_apless
sapotes9313943sapot_e_s
sashless1136603sashless
savorless1243213savorless
scarless10189053scarless
scentless1135113scentless
scoreless1155603scoreless
scoters93313813scot_ers
scowlers13257373scowlers
scumless1254993scumless
seamless10238723seamless
seedless9319513seedless
selfless1135013selfless
settlers8289023settlers
settles73916003settle_s
sexless1467243s_exless
sheetless1235823sheetless
shiftless15265303shiftless
shipless13277693shipless
shirtless12266413shirtless
shoalest1168913shoalest
shoreless1236633shoreless
shortness1236733shortness
shotes95321913shot_e_s
sighless1276553sighless
sightless1385923sightless
sinless73014213s_inless
skilless12246763skilless
skinless12216973skinless
skirtless13254423skirtless
slipless10246993slipless
slotters84012403slotters
slowness1135013slowness
smokeless1543553smokeless
smothers13349933smothers
snapless10287463snapless
soapless10278073soapless
sockless14267793sockless
socles8418453s_ocle_s
sodaless936113sodaless
softness1136433softness
soilless8279033soilless
soleless8910033soleless
soles55547923s_o_le_s
soleus64615613s_o_leus
songless9218823songless
soothers113913433soothers
soothes103917113soothe_s
soothest113312243soothest
sootiest84016753sootiest
sootiness999833sootiness
soulless8218763soulless
soupless10268463soupless
spaceless1335733spaceless
spales84728103sp_ale_s
spallers102910733spallers
spates85028173spat_e_s
spathes125116533spathe_s
spatters103914703spatters
spatzles1935303spatzle_s
spellers102812753spellers
spelters103912243spelters
spiceless1335923spiceless
spielers10319653spielers
spiles84227913sp_ile_s
spillers103311703spillers
spineless1136133spineless
spiritless1243743spiritless
spites84127333spit_e_s
spitters104113383spitters
spittles1038333spittle_s
spitzes1849183spitze_s
spodes94817433spo_de_s
spoiled104811353spoile_d
spoiler93310683spoile_r
spoils84614533spoil__s
spokes124417213spo_ke_s
spondees1136483spondees
spongers1137603spongers
sponges10311043sponge_s
spoofers13307323spoofers
spooled104613523spoole_d
spooler93711383spoole_r
spools85115913spool__s
spooneys13314583spooneys
spores84726613spo_re_s
sporters103714063sporters
sportiest111711023sportiest
sportiness1278233sportiness
sporules1037703sporule_s
spotlit947303spotl_it
spots74424113spot___s
spotted103713143spotte_d
spotter94514883spotte_r
spottiest11177683spottiest
spottiness1285763spottiness
spouses92912813spouse_s
spouters104011163spouters
spryness1334003spryness
spurtles1037783spurtle_s
sputters104012873sputters
spyglass1442253spyglass
starless81610843starless
stateless937563stateless
stemless1036653stemless
stoles63927673sto_le_s
stollens835293stollens
stoutness945863stoutness
stress66616673s__tress
subtlest10511363subtlest
suckless14288823suckless
sudsless944353sudsless
sumless92611123s_umless
sunless73013693s_unless
sutlers73116973s_utlers
swotters11448483swotters
tactless10288463tactless
tentless8229843tentless
textless15245793textless
thowless1434613thowless
tintless8239863tintless
toeless72612393_toeless
toolless836343toolless
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
toyless10268713_toyless
vaporless1443163vaporless
ventless11249053ventless
vestless11258843vestless
voteless1137493_voteless
votress1035483_votress
vowless13246603_vowless
wartless11279923wartless
wattless11268723wattless
witless103310983_witless
woodless12278453woodless
zestless17247433zestless

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.420425454.8
2DLD Change Limit1461622617.37619815.9
3Display Results2612610.1102372.7
 (SQL Overall)1786912617.90622601.9
 
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.