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

162 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
smogless113405(None) 
fogless1138192_fogless
shoeless1137802shoeless
smokeless1543552smokeless
smugness1143812smugness
snowless1145612snowless
songless9218822songless
sonless72612612s_onless
spotless1037042spotless
amoles84122193amo_le_s
armorless1143483armorless
blotless10347143blotless
bogles95020833_bogle_s
boonless10328353boonless
bootless103410983bootless
bowless123310313_bowless
browless1346653browless
cookless14258633cookless
coxless1637743_coxless
cropless1237793cropless
doglegs1034783_doglegs
doorless936713doorless
eggless935663_eggless
egoless836983ego_less
fangless1237663fangless
flagless1235403flagless
foodless12338383foodless
footless113710803footless
froglets1235263froglets
godless938403_godless
goglets9379783_goglets
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279253hoopless
humorless1442963humorless
isogloss943363isogloss
jagless1537103_jagless
jobless16237563_jobless
joyless17226513_joyless
kingless13288693kingless
knotless1264563knotless
legless838013_legless
maglevs1334693_maglevs
manless93012933_manless
matless93014043_matless
moilers93615203_moilers
moles74747923_mo_le_s
molest85022743_mo_lest
molests93311563_mo_lests
mooleys1236863_mooleys
moonless10278043moonless
motleys1235683_motleys
moveless1367753_moveless
odorless934173odorless
oglers74313183__oglers
ogles65223183__ogle_s
ogress7529503__ogress
osmoles9138363osmo_le_s
pegless1038053_pegless
plotless10256793plotless
plugless1133863plugless
progress1137023progress
rodless8310073_rodless
roofless11316733roofless
rootless83910443rootless
rungless956733rungless
sailless82410363sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443s_apless
sashless1136603sashless
savorless1243213savorless
scarless10189053scarless
scoreless1155603scoreless
scowlers13257343scowlers
scumless1254993scumless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
semigloss1243343semigloss
sexless1467243s_exless
shipless13277693shipless
shitless11249243shitless
shoalest1168913shoalest
shoreless1236633shoreless
sighless1276553sighless
singles83520433single_s
singlets93611473singlets
sinless73014213s_inless
skilless12246753skilless
skinless12216973skinless
slipless10246993slipless
slitless8268143slitless
sloggers10418783sloggers
slowness1135013slowness
smallest1039403smallest
smallness1174513smallness
smellers10329753smellers
smileless1134693smileless
smilers94113843sm_ilers
smiles84522293sm_ile_s
smileys12336323sm_ileys
smoggiest1334463smoggiest
smogs85112163smog___s
smokers13389323smo_kers
smokes124814343smo_ke_s
smokiest1437883smokiest
smokiness1535543smokiness
smolders11287193smolders
smolts84411883smo_l_ts
smothers13349933smothers
smoulders1243133smoulders
smuggest1244373smuggest
smugglers13263433smugglers
smuggles12225443smuggle_s
snapless10287463snapless
sniglets9276813sniglets
snugness934323snugness
soapless10278073soapless
sockless14267793sockless
socles8418453s_ocle_s
sodaless936113sodaless
soilless8279023soilless
soleless8910033soleless
soles55547923s_o_le_s
soleus64615613s_o_leus
soulless8218763soulless
soupless10268463soupless
spanless10247363spanless
spinless10238703spinless
spoilers10238633spoilers
spoolers10349363spoolers
spoutless1134243spoutless
spyglass1442253spyglass
starless81610843starless
stemless1036653stemless
stingless1046463stingless
stogeys11486123stog_eys
stogies8413693stogie_s
stoles63927673sto_le_s
stollens835283stollens
suckless14288823suckless
sudsless944353sudsless
sumless92611123s_umless
sunglass945093sunglass
sunless73013693s_unless
thowless1434613thowless
toeless72612393_toeless
tombless1236773tombless
toolless836343toolless
topless92511123_topless
toyless10268713_toyless
tugless837383_tugless
twigless1293663twigless
vowless13246603_vowless
wigless11359673_wigless
wingless122910023wingless
woodless12278453woodless
zoogleas1843373zoogleas

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 Limit1461621627.25020160.3
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.46923924.4
 
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.