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

298 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
boonless1032835(None) 
bootless103410981bootless
moonless10278041moonless
bloodless1234512bloodless
bloomless1342962bloomless
blotless10347152blotless
bodiless1135912bodiless
boltless10338282boltless
bondless1148812bondless
boneless10310212boneless
boodlers113710742boodlers
boodles103416042boodle_s
booklets14247122booklets
boomlets12246672boomlets
boonies93422482boonie_s
bootlegs11325872bootlegs
boundless1235182boundless
bowless123310312b_owless
broodless1235032broodless
browless1346652browless
cookless14258632cookless
coolness1037742coolness
doorless936712doorless
downless1236362downless
foodless12338382foodless
footless113710802footless
hoodless12289732hoodless
hoofless14258012hoofless
hookless151238362hookless
hoopless13279262hoopless
hornless1137362hornless
moonlets10247472moonlets
nounless837252nounless
roofless11316732roofless
rootless83910442rootless
sonless72612612_sonless
toolless836342toolless
townless1135652townless
woodless12278452woodless
awnless1035923_awnless
backless162910633backless
badness1039573badn_ess
barbless12318713barbless
barkless14318023barkless
barless94317003b_arless
baroness101210063baron_ess
baseless1099563baseless
bathless13127383bathless
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bedless1039703b_edless
beefless1335493beefless
beltless10297713beltless
bibless11439173b_ibless
bigness1038193bign_ess
bless75917813b___less
blondes104213163blonde_s
blondest11419243blondest
blondness1234963blondness
bobbles104514913bobble_s
bobsleds13304383bobsleds
bogglers12347603bogglers
boggles113411823boggle_s
bogles95020833b_ogle_s
boilers93417063b_oilers
boldness1136973boldness
boles75448603b_o_le_s
boloneys1334503bolon_eys
bomblets1436023bomblets
bonders104120663b_onders
boners84825433b_on_ers
bones76446533b_on_e_s
boniest93318993b_oniest
boniness102211803boniness
bonkers134015303b_onkers
bonnes85621453b_onne_s
bonnets94812803b_onnets
bonniest10310773bonniest
bonniness1136733bonniness
bonuses94212953b_onuses
bonzes175116103b_onze_s
boobies113718203boobie_s
boodies103721443boodie_s
boodle93215033boodle__
boodled113410933boodle_d
boodler103312003boodle_r
boogers104514633boo_gers
boogeys13476873boo_geys
boogies103719013boogie_s
bookers134016613boo_kers
bookies133819403bookie_s
booklet132312643bookle_t
bookrest1436493bookrest
bookrests1542623bookrests
boomers114115913boo_mers
boomiest122711843boomiest
boomlet112412273boomle_t
boons75031913boon___s
boosters104013443boosters
bootees94114473boo_tees
booties94124613bootie_s
bootleg10276633bootle_g
bootlessly1553423bootlessly
boozers183912443boo_zers
boozes174916523boo_ze_s
booziest19379263booziest
booziness20135613booziness
bottlers103810013bottlers
bottles94216273bottle_s
bottomless1442053bottomless
boucles113113003boucle_s
boughless1543873boughless
boules84925973b_oule_s
boulles93114123boulle_s
bouncers12309353bouncers
bounces113813683bounce_s
bounders114314113bounders
boundness1235943boundness
bowelless1443833bowelless
bowlegs13366823b_owlegs
bowlers123715783b_owlers
boxiness17247813boxiness
brainless1136403brainless
braless92910563b_raless
brandless1236123brandless
brimless1235273brimless
brineless1136243brineless
broilers103210093broilers
bronzers19296983bronzers
bronzes183510403bronze_s
brooklets1543683brooklets
brownness1444343brownness
budless1038873b_udless
bushless1335813bushless
buttonless1242963buttonless
chinless1337493chinless
coalless1038193coalless
coatless1039693coatless
codeless112010113codeless
colorless1145683colorless
confess12399903_confess
coolers93522493coo_lers
coolest9318643coo_lest
cordless11299963cordless
coreless103013833coreless
costless10310003costless
countess103710053countess
countless1146373countless
coxless1637743_coxless
coyness1277323coyn_ess
cropless1237793cropless
crownless1443423crownless
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doo_lees
egoless836983ego_less
fernless1136063fernless
finless102810783_finless
floorless1243793floorless
foamless13195843foamless
fogless1138193_fogless
footlers113910793footlers
footles103715713footle_s
foozlers20346073foozlers
foozles19329543foozle_s
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulness11236653foulness
frontless1235403frontless
gainless9117403gainless
goalless935723goalless
godless938403_godless
goodness1036253goodness
gooneys11407073goon_eys
goonies83618333goonie_s
gooniest93213003gooniest
gormless11235443gormless
gunless8299633_gunless
holeless1189363holeless
homeless131110133homeless
hooklets15217203hooklets
hopeless13118303hopeless
hotness1038613hotn_ess
hymnless1632803hymnless
innless7288293_innless
ironness836953ironness
jobless16237563_jobless
jointless1634323jointless
joyless17226513_joyless
kinless113310273_kinless
knotless1264573knotless
lioness739103lion_ess
loamless10235213loamless
loftless1135903loftless
looneys10487013loon_eys
loonies73919543loonie_s
looniest83313253looniest
looniness9137573looniness
lordless9277483lordless
lornness836493lornness
lossless835473lossless
loveless1168573loveless
lowness1037813lown_ess
manless93012933_manless
mooleys1236863moo_leys
mooners94015343moon_ers
mooniest103014173mooniest
mooniness11157863mooniness
moonlet92413273moonle_t
moonsets10216413moonsets
mootness1036753mootness
motionless1243483motionless
motorless1145723motorless
moveless1367753moveless
noodles83513193noodle_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nowness1037033nown_ess
oarless73913373_oarless
oboles83815833obo_le_s
odorless934173odorless
oodles73517183_oodle_s
orbless937493_orbless
painless10108343painless
planless1036813planless
plotless10256793plotless
poetless1038723poetless
pointless1135703pointless
poleless1089873poleless
poodles103013513poodle_s
poolers94217423poo_lers
poorness1036363poorness
popeless1288473popeless
portless10310643portless
rainless8129703rainless
reinless8139433reinless
roadless937703roadless
rockless14297293rockless
rodless8310073_rodless
rootles73215633rootle_s
rootlets8308653rootlets
runless72810423_runless
shoeless1137803shoeless
sinless73014213_sinless
skinless12216973skinless
smogless1134053smogless
snowless1145633snowless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sooners73916643soon_ers
soonest7415593soon_est
soulless8218763soulless
soundless1035533soundless
soupless10268463soupless
spanless10247363spanless
spinless10238703spinless
spotless1037043spotless
sunless73013693_sunless
thornless1243633thornless
thowless1434613thowless
toadless936313toadless
toeless72612393_toeless
tombless1236783tombless
toneless8610393toneless
tonlets73212503_tonlets
toolers74416503too_lers
toonies73719883toonie_s
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123_topless
townlets1134773townlets
toyless10268713_toyless
unless62413073__unless
veinless11136263veinless
voteless1137493voteless
vowless13246603_vowless
winless103212283_winless
woeness1020211543woen_ess
womanless1443383womanless
woolens10398843woo_lens
woolers104214023woo_lers
woollens1144093woollens
wordless12258843wordless
workless15276803workless
wornness1136363wornness
woundless1334033woundless
yokeless1535303yokeless
zoneless1737823zoneless
zoogleas1843373zoogleas
zoonoses1746203zoonoses

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.440406115.9
2DLD Change Limit1461622986.31323152.5
3Display Results2982980.1402128.6
 (SQL Overall)1786912986.89325923.5
 
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.