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

263 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
soupless1026846(None) 
soapless10278071soapless
soulless8218761soulless
couplers123311312couplers
couples115317052couple_s
couplets12389872couplets
hoopless13279252hoopless
nounless837252nounless
sapless93313442s_apless
scumless1254992scumless
shipless13277692shipless
slipless10246992slipless
snapless10287462snapless
sockless14267792sockless
sodaless936112sodaless
soilless8279022soilless
soleless8910032soleless
songless9218822songless
sonless72612612so_nless
soundless1035532soundless
soupiest102212902soupiest
sourness839542sourness
spoutless1134242spoutless
sumless92611122s_umless
sunless73013692s_unless
topless92511122to_pless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
boucles113113003boucle_s
boughless1543873boughless
boules84925973bou_le_s
boulles93114123boulle_s
boundless1235183boundless
bowless123310313bo_wless
budless1038873_budless
capless114312763_capless
cloudless1243153cloudless
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
codeless112010113codeless
compress1439053compress
cookless14258633cookless
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coulees9315503cou_lees
countess103710043countess
countless1146373countless
coupes105022523coup_e_s
couple104415963couple__
coupled124312673couple_d
coupler114713013couple_r
couplet114717943couple_t
coxless1637743co_xless
cropless1237793cropless
doorless936713doorless
doublers11288493doublers
doubles103113353double_s
doublets11257363doublets
doubtless1243313doubtless
dourness947683dourness
downless1236363downless
dripless1135243dripless
flapless1335343flapless
flourless1243533flourless
foamless13195843foamless
focusless1452263focusless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulest10313313fou_lest
foulness11236653foulness
furless103210143_furless
gapless10349993_gapless
goalless935723goalless
godless938403go_dless
gormless11235443gormless
gumless10228273_gumless
gunless8299633_gunless
gutless82610713_gutless
hapless123311333_hapless
helpless1335063helpless
hipless12399923_hipless
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hopeless13118303hopeless
hopples142810713hopple_s
hornless1137363hornless
hotpress1344293hotpress
houseless1237463houseless
hueless1058823_hueless
humpless15226333humpless
issueless942393issueless
jobless16237563jo_bless
joules134116823jou_le_s
joyless17226513jo_yless
koupreys1741733koupreys
lipless9259553_lipless
loamless10235213loamless
loftless1135903loftless
lordless9277483lordless
lossless835473lossless
loudness937013loudness
loupes84918053loup_e_s
loveless1168573loveless
moonless10278043moonless
mouthless1444713mouthless
moveless1367753moveless
napless93110283_napless
nonuples1056533nonuple_s
normless10235923normless
noseless839513noseless
noteless839403noteless
oarless73913373_oarless
oppress1135993_oppress
orbless937493_orbless
ouphes113614633_ouphe_s
outbless1037963_outbless
outlets73616363_outlets
outpress10118173_outpress
plugless1133863plugless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
popples103011873popple_s
portless10310643portless
pulpless12224953pulpless
pumpless14236373pumpless
roadless937693roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
roubles93413503rouble_s
roupiest102610293roupiest
rumpless12256543rumpless
runless72810423_runless
sailless82410363sailless
saltless8259343saltless
samplers12299403samplers
samples112815453sample_s
sandless93212343sandless
sashless1136603sashless
scarless10189053scarless
scoreless1155603scoreless
scruples1237433scruple_s
scullers103510473scullers
scuppers1446533scuppers
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243s_exless
shapeless1435563shapeless
shitless11249243shitless
shoeless1137803shoeless
shoreless1236633shoreless
sighless1276553sighless
simples113014943simple_s
simplest122310223simplest
sinless73014213s_inless
skilless12246753skilless
skinless12216973skinless
sleepless1144553sleepless
slitless8268143slitless
smogless1134053smogless
smokeless1543553smokeless
smugness1143813smugness
snowless1145613snowless
snubness1044373snubness
snugness934323snugness
soapers93715923soap_ers
soapiest102412843soapiest
soapiness1138293soapiness
socles8418453so_cle_s
softness1136433softness
soleness8814263soleness
soles55547923so__le_s
soleus64615613so__leus
solubles1065893soluble_s
soppiest122511933soppiest
soppiness1336543soppiness
soreness8914793soreness
soubises10107993soubises
souffles14298113souffle_s
souled75419823sou_le_d
soullessly1343053soullessly
souls55127363sou_l__s
sounders93214103sounders
soundest9510973soundest
soundness1036963soundness
soupcons1244373soupcons
souped95017673soup_e_d
soupier93111753soupie_r
souplike1436333souplike
soups75322943soup___s
sourceless1273013sourceless
sources9312173source_s
sourest7515713sou_rest
sourpuss1042313sourpuss
souses64229243sou_se_s
sousliks1244003sousliks
souters74422583sou_ters
southers114214453southers
spanless10247363spanless
spinless10238703spinless
spotless1037043spotless
stampless1334543stampless
staplers103111183staplers
staples93617213staple_s
starless81610843starless
stemless1036653stemless
stopples1236953stopple_s
stoutness945853stoutness
strapless1135783strapless
stuffless1543523stuffless
stupes84116953stup_e_s
sublets92616703s_ublets
success1146403s_uccess
suckless14288823suckless
sudsless944353sudsless
supers84622403s_up_ers
supes75628303s_up_e_s
suppers113314693s_uppers
supples11511283supple_s
supplest1248933supplest
suppress1236443suppress
sutlers73116973s_utlers
swiples12339643swiple_s
tipless92610063_tipless
toadless936303toadless
toeless72612393to_eless
tombless1236773tombless
toneless8610393toneless
toolless836343toolless
topples113111653topple_s
toupees938513toup_ees
tousles74113933tousle_s
touzles16359223touzle_s
townless1135653townless
toyless10268713to_yless
tugless837383_tugless
unless62413073__unless
voteless1137493voteless
vowless13246603vo_wless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
woundless1334033woundless
yokeless1535303yokeless
zipless18276303_zipless
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.1561145455.1
2DLD Change Limit1461622636.90621164.5
3Display Results2632630.1102390.9
 (SQL Overall)1786912637.17224915.1
 
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.