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

237 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
blotless1034715(None) 
boltless10338281boltless
bootless103410981bootless
plotless10256791plotless
beatless103311592beatless
beltless10297712beltless
bloodless1234512bloodless
bloomless1342962bloomless
blotters104110982blotters
boonless10328352boonless
bootlegs11325872bootlegs
bowless123310312b_owless
browless1346652browless
footless113710802footless
knotless1264572knotless
loftless1135902_loftless
pilotless1143992pilotless
rootless83910442rootless
slitless8268142slitless
spotless1037042spotless
artless73712513_artless
backless162910633backless
barbless12318713barbless
barkless14318023barkless
barless94317003b_arless
baseless1099563baseless
bathless13127383bathless
battlers104110973battlers
battles94517683battle_s
beakless14297383beakless
beamless12327003beamless
bedless1039703b_edless
beefless1335493beefless
beetlers1037393beetlers
beetles9312083beetle_s
bibless11439173b_ibless
bladeless1234303bladeless
blameless1334733blameless
blathers134713793blathers
blatters104414093blatters
bless75917813b___less
blethers13429613blethers
blissless1142633blissless
blites84721213blit_e_s
blithers134711233blithers
blithest1338083blithest
blitzers19417153blitzers
blitzes18408703blitze_s
bloaters103311023bloaters
blockers16398793blockers
bloggers12397403bloggers
blokes123813883blo_ke_s
blondes104213163blonde_s
blondest11419243blondest
blondness1234963blondness
bloomers12348823bloomers
bloopers12397373bloopers
blotches1537433blotches
blots75626173blot___s
blotted103911833blotte_d
blotter94612853blotte_r
blottiest11286833blottiest
blouses94014463blouse_s
blowers124313593blo_wers
blowiest1337923blowiest
blowiness1435623blowiness
blueness1038213blueness
bluntness1144343bluntness
bodiless1135913bodiless
bogles95020833b_ogle_s
boilers93417063b_oilers
boldness1136973boldness
boles75448603b_o_le_s
bolters94017803bolt_ers
bondless1148813bondless
boneless10310213boneless
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
bootees94114473boot_ees
booties94124613bootie_s
bootleg10276633bootle_g
bootlessly1553423bootlessly
botels84815803b_ot_els
bothers124317753b_others
bottlers103810013bottlers
bottles94216273bottle_s
boules84925973b_oule_s
bowlegs13366823b_owlegs
bowlers123715783b_owlers
bractless1335543bractless
braless92910563b_raless
brimless1235273brimless
broilers103210093broilers
broodless1235033broodless
brothels13277073brothels
brothers133410833brothers
budless1038873b_udless
bushless1335813bushless
bustlers104210613bustlers
bustles93816323bustle_s
butlers94518053b_utlers
butles84423913b_utle_s
buttress1035883buttress
clawless1334123clawless
clothes124513813clothe_s
cloudless1243153cloudless
clueless1035883clueless
coatless1039693coatless
colorless1145683colorless
cookless14258633cookless
costless10310003costless
coxless1637743_coxless
cropless1237793cropless
debtless1135653debtless
doorless936713doorless
ductless11196313ductless
dustless9328353dustless
egoless836983ego_less
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
flagless1235403flagless
flapless1335343flapless
flatlets1147373flatlets
flatness1138153flatness
flawless1434503flawless
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
flyless1335003fl_yless
fogless1138193_fogless
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
fretless1138063fretless
frontless1235403frontless
frostless1235743frostless
giftless1245173giftless
godless938403_godless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
holeless1189363holeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hotness1038613_hotness
hurtless11307783hurtless
jobless16237563_jobless
joyless17226513_joyless
lawless1037033_lawless
legless838013_legless
lidless8309273_lidless
lintless82710013lintless
lipless9259553_lipless
listless8269263listless
loamless10235213_loamless
loess55714703_lo__ess
lollers72713793_lollers
lordless9277483_lordless
lossless835473_lossless
lostness837683_lostness
lotoses73713643_lotoses
lotters73921063_lotters
lottes65322753_lotte_s
lotuses74011253_lotuses
loveless1168573_loveless
lowness1037813_lowness
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
moonless10278043moonless
mootness1036753mootness
motleys1235683_motleys
netless739863_netless
noteless839403_noteless
odorless934173odorless
pastless102411203pastless
peltless10267373peltless
planless1036813planless
playless1334863playless
pleatless1134613pleatless
plotters104011553plotters
plotzes18317703plotze_s
plugless1133863plugless
poetless1038723poetless
poleless1089873poleless
portless10310643portless
restless82713163restless
riftless1136943riftless
rodless8310073_rodless
roofless11316733roofless
rootles73215633rootle_s
rootlets8308653rootlets
rustless83510243rustless
saltless8259343saltless
seatless83213003seatless
shitless11249243shitless
shoeless1137803shoeless
slipless10246993slipless
slotters84012403slotters
slowness1135013slowness
smogless1134053smogless
snowless1145633snowless
soleless8910033soleless
sonless72612613_sonless
spoutless1134243spoutless
tactless10288463tactless
tentless8229843tentless
textless15245793textless
thowless1434613thowless
tintless8239863tintless
toeless72612393_toeless
toolless836343toolless
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
toyless10268713_toyless
ventless11249053ventless
vestless11258843vestless
voteless1137493_voteless
votress1035483_votress
vowless13246603_vowless
wartless11279923wartless
wattless11268723wattless
witless103310983_witless
woodless12278453woodless
zestless17247433zestless
zloties1639913zlotie_s

Search took 9 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.406440125.6
2DLD Change Limit1461622377.62319173.8
3Display Results2372370.0932548.4
 (SQL Overall)1786912378.12222000.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.