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

166 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
scumless125499(None) 
sumless92611121s_umless
gumless10228272_gumless
scarless10189052scarless
scullers103510472scullers
scumbles1447022scumble_s
scummers14277782scummers
seamless10238722seamless
soulless8218762soulless
soupless10268462soupless
stemless1036652stemless
suckless14288822suckless
sunless73013692s_unless
aculeus937513acu_leus
acumens1136953acum_ens
aimless93610813_aimless
armless9369943_armless
beamless12327003beamless
brimless1235273brimless
budless1038873_budless
camlets114314623_camlets
capless114312763_capless
carless95118493_carless
clueless1035883clueless
coxless1637743_coxless
cuffless1634283_cuffless
culets85518513_cu_lets
cullers93418843_cullers
cullets94015613_cullets
cumbers134515393_cumbers
cummers133713473_cummers
cureless10319703_cureless
curlers94218063_curlers
curlews12387393_curlews
cutlass938013_cutlass
cutlers94216993_cutlers
cutlets94113653_cutlets
ductless11196313ductless
echoless1345603echoless
filmless1344553filmless
foamless13195843foamless
focusless1452263focusless
formless13248083formless
fumeless13236603_fumeless
furless103210143_furless
glumness1135203glumness
gormless11235443gormless
gunless8299633_gunless
gutless82610713_gutless
harmless1337403harmless
helmless1334273helmless
hueless1058823_hueless
humpless15226333_humpless
iceless9219963ic_eless
issueless942393issueless
loamless10235213loamless
luckless14265893luckless
normless10235923normless
nounless837253nounless
oscules938123oscu_le_s
plugless1133863plugless
pumpless14236373_pumpless
rimless9369363_rimless
rumpless12256543_rumpless
runless72810423_runless
sailless82410363sailless
saltless8259343saltless
samlets93813553s_amlets
sandless93212343sandless
sapless93313443s_apless
sashless1136603sashless
scaleless1135513scaleless
scalers93817263sc_alers
scales84529313sc_ale_s
scammers14339773scammers
scampers143611033scampers
scarlets10178573scarlets
scentless1135113scentless
schleps1445483sc_hleps
schmeers1574833schmeers
schmoes14308543schmoe_s
scoreless1155603scoreless
scowlers13257343scowlers
scruples1237433scruple_s
scuffers16307493scuffers
scufflers17285023scufflers
scuffles16287853scuffle_s
sculkers14306933sculkers
sculks123610263scu_l_ks
sculled102911693sculle_d
sculler99812153sculle_r
scullery13296333scullery
sculls84613883scu_l_ls
sculps104611753scu_l_ps
sculpts11377063scu_lpts
scumbags1543203scumbags
scumble1337013scumble__
scumbled1535053scumble_d
scumlike1644353scumlike
scummed14347913scumme_d
scummer13398753scumme_r
scummiest1535203scummiest
scums95017423scum___s
scunners10357303scunners
scuppers1446533scuppers
scutes85219193scu_te_s
scutters103311013scutters
scuttles1056503scuttle_s
scuzzes1734403scuzze_s
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243s_exless
shameless1435923shameless
shipless13277693shipless
shitless11249243shitless
shoeless1137803shoeless
sighless1276553sighless
sinless73014213s_inless
skilless12246753skilless
skinless12216973skinless
slimness1036523slimness
slipless10246993slipless
slitless8268143slitless
slumbers123110273slumbers
slummers12358933slummers
smogless1134053smogless
smugness1143813smugness
snapless10287463snapless
snowless1145613snowless
snubness1044373snubness
snugness934323snugness
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279023soilless
soleless8910033soleless
songless9218823songless
sonless72612613s_onless
soundless1035533soundless
sourness839543sourness
spanless10247363spanless
spinless10238703spinless
spotless1037043spotless
spoutless1134243spoutless
spumes1021314883spum_e_s
spumiest1238193spumiest
stampless1334543stampless
starless81610843starless
stuffless1543523stuffless
stumblers1334373stumblers
stumbles1237493stumble_s
stumpers12318313stumpers
sublets92616703s_ublets
success1146403s_uccess
suchness1335763suchness
sucklers14379963sucklers
suckles134516743suckle_s
sudsless944353sudsless
summers113616503s_ummers
sutlers73116973s_utlers
termless1036233termless
thumbless1643423thumbless
tramless1037503tramless
tugless837383_tugless
unless62413073__unless

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.326548131.9
2DLD Change Limit1461621668.93616356.5
3Display Results1661660.0802075.0
 (SQL Overall)1786911669.34219127.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.