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

147 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
smooshes1320686(None) 
smooches15217261smooches
smooshed14185991smooshed
smoothes13218531smoothes
swooshes14185121swooshes
mooches143714452_mooches
moshes115222872_m_oshes
scooches15188412scooches
skoshes14246242s_koshes
sloshes103811802s_loshes
smashes123914612sm_ashes
smooched16185982smooched
smoocher15205502smoocher
smoochers16184832smoochers
smoosh11236732smoosh__
smoothed14236462smoothed
smoothen13204952smoothen
smoothens14194252smoothens
smoother13196662smoother
smoothers14206042smoothers
smoothest14215772smoothest
smoothies1456122smoothies
smooths12216312smooth_s
smushes123710092sm_ushes
soothes103917102s_oothes
sploshes1336132sploshes
squooshes2142542squooshes
swooshed15174272swooshed
whooshes1734412whooshes
wooshes13169882_wooshes
ambushes1535803ambushes
boshes114721883__boshes
brooches15288193brooches
chooses125717413choos_es
choushes1637623choushes
cohoshes1635873cohoshes
cooches143515833_cooches
coshes115022783__coshes
embosses1235963embosses
emdashes14224303emdashes
floosies113210233floosies
galoshes1236893galoshes
goloshes1236253goloshes
gooses75723053_goos_es
hooches153812523_hooches
immeshes1543933immeshes
imposes113213683impos_es
joshes165114853__joshes
kiboshes1744013kiboshes
kyboshes2042743kyboshes
looses67328243_loos_es
marshes123615373_marshes
mashes115030003_m_ashes
menshes12310443_menshes
meshes115019443_m_eshes
mioses84318853_mios_es
monishes13311483_monishes
mooched153910533_mooched
moocher143610673_moocher
moochers15369123_moochers
moorhen1236023_moorhen
moorhens1344843_moorhens
moose76327193_moos_e_
moshed124517493_m_oshed
mosher114719793_m_osher
moshers124017843_m_oshers
mosses85527683_m_osses
mouches143815963_mouches
mouses85531423_mous_es
mousses94012703_mousses
mushes114124563_m_ushes
myoses114013843_myos_es
nooses65623643_noos_es
noshes96618233__noshes
osmoses9138123osm_os_es
pooches143214163_pooches
rooses65526233_roos_es
saroses73619333saros_es
sashes94728483s__ashes
schmooses16275623schmoos_es
scooched16206683scooched
scootches1635003scootches
scorches15189143scorches
scotches15179473scotches
scouses93313243scous_es
scrooches1645703scrooches
semioses10611013semios_es
shmoozes22254863shmoo_zes
shushes133510303s_hushes
slashes103619103s_lashes
sloshed11329823s_loshed
slouches13208073slouches
slushes103514413s_lushes
smashed133711223sm_ashed
smasher123911013sm_asher
smashers13339583sm_ashers
smirches1535993smirches
smokes124814343sm_o_kes
smooch13266803smooch__
smoochy17223863smooch_y
smooshing1534793smooshing
smooth11259193smooth__
smoothie1344873smoothie
smoothly16203633smoothly
smoothness1543043smoothness
smoothy15205073smooth_y
smother123510203sm_other
smothers13349933sm_others
smushed13368233sm_ushed
smutches15177273smutches
snashes105214753s_nashes
sneeshes1136513sneeshes
snoozes16289763snoo_zes
snoozles17335563snoozles
snowshed1534413snowshed
snowsheds1642853snowsheds
snowshoes1543683snowshoes
soothe94214843s_oothe_
soothed113712733s_oothed
soother104215033s_oother
soothers113913433s_oothers
soothest113312243s_oothest
sooths95715583s_ooth_s
soroches1338803soroches
soroses73117483soros_es
souses64229243s_ous_es
splashes1337503splashes
sploshed1434323sploshed
spoonies101911753spoonies
spouses92912813spous_es
squashes20207803squashes
squishes20198383squishes
squooshed2241843squooshed
squushes20194673squushes
stashes103916163s_tashes
stonishes1247363stonishes
stooges83611483stoo_ges
stoolies8311083stoolies
strophes13310593strophes
swashes134714403s_washes
swishes133411373s_wishes
swoosh12195213swoosh__
sycoses1249133sycos_es
toshes94520103__toshes
vamooses1345523vamoos_es
whooshed1833453whooshed
wooshed14167403_wooshed

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.1561145455.1
2DLD Change Limit1461621478.56317069.0
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.78220347.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.