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

157 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
smooches1521726(None) 
mooches143714451_mooches
scooches15188411scooches
smooched16185981smooched
smoocher15205501smoocher
smoochers16184831smoochers
smooshes13206861smooshes
smoothes13218531smoothes
brooches15288192brooches
cooches143515832_cooches
hooches153812522_hooches
mooched153910532_mooched
moocher143610672_moocher
moochers15369122_moochers
mouches143815962_mouches
pooches143214162_pooches
scooched16206682scooched
scootches1635002scootches
scorches15189142scorches
scotches15179472scotches
scrooches1645702scrooches
slouches13208072slouches
smirches1535992smirches
smooch13266802smooch__
smoochy17223862smooch_y
smooshed14185992smooshed
smoothed14236462smoothed
smoothen13204952smoothen
smoothens14194252smoothens
smoother13196662smoother
smoothers14206042smoothers
smoothest14215772smoothest
smoothies1456122smoothies
smooths12216312smooth_s
smutches15177272smutches
soothes103917102s_oothes
soroches1338802soroches
swooshes14185122swooshes
avouches1634823avouches
blotches1537433blotches
boches134618523__boches
botches143716023_botches
brioches15227253brioches
broaches153211623broaches
caroches15710693caroches
cloches144113713_cloches
coaches144018693_coaches
conches144019813_conches
couches144020463_couches
crotches153411293crotches
crouches153711283crouches
douches134315233_douches
grouches14328213grouches
hoochies1639593_hoochies
hootches1656973hootches
hotches153814363_hotches
loaches123613983_loaches
maches134827233_m_aches
manches143818623_manches
marches143921173_marches
matches143219783_matches
merches144013763_merches
miches134320733_m_iches
mochas13310653_m_ochas
molochs1435223_moloch_s
monocles12310673_monocles
mooch125313613_mooch__
moorhen1236023_moorhen
moorhens1344843_moorhens
moshes115222873_m_oshes
mouched153612593_mouched
muches134718993_m_uches
mulches143210673_mulches
munches144215793_munches
mutches143314283_mutches
notches123513653_notches
ouches114322183__ouches
panoches1548123panoches
penoches1538933penoches
poaches144416943_poaches
pooched152810083_pooched
porches143815673_porches
pouches144116743_pouches
roaches123616213_roaches
rotches123515703_rotches
rouches124217893_rouches
sconces113811453sconc_es
scooch13228123scooch__
scootched1763963scootched
scorched16187193scorched
scorcher15196783scorcher
scorchers16145513scorchers
scotched16187933scotched
scrooched1763843scrooched
scrootches1743323scrootches
sculches15176273sculches
scutches15168883scutches
searches132112903searches
seiches12513813s_eiches
seviches1635803seviches
shmoozes22254863shmoo_zes
sketches1746823sketches
skoshes14246243s_koshes
slatches131511523slatches
sloshes103811803s_loshes
slouched14206743slouched
sloucher13206813sloucher
slouchers14185623slouchers
smashes123914613sm_ashes
smirched1634673smirched
smocked16398223sm_ocked
smocks145710013sm_oc_ks
smokes124814343sm_o_kes
smooching1734883smooching
smoosh11236733smoosh__
smooth11259193smooth__
smoothie1344873smoothie
smoothly16203633smoothly
smoothness1543043smoothness
smoothy15205073smooth_y
smother123510203sm_other
smothers13349933sm_others
smushes123710093sm_ushes
smutched16165923smutched
snatches131410713snatches
snitches13148983snitches
snoozes16289763snoo_zes
snoozles17335563snoozles
socles8418453s__ocles
soothe94214843s_oothe_
soothed113712733s_oothed
soother104215033s_oother
soothers113913433s_oothers
soothest113312243s_oothest
sooths95715583s_ooth_s
soroche1237183soroche_
speeches1537413speeches
sploshes1336133sploshes
splotches1643913splotches
spoonies101911753spoonies
squooshes2142543squooshes
stanches132312793stanches
starches131912913starches
stenches132110293stenches
stitches131410593stitches
stooges83611483stoo_ges
stoolies8311083stoolies
strophes13310593strophes
swatches16169963swatches
switches16159133switches
swooshed15174273swooshed
torches123715433_torches
touches125118343_touches
troches123715343_troches
vouches153914113_vouches
whooshes1734413whooshes
wooshes13169883_wooshes

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.1601116818.8
2DLD Change Limit1461621577.15320433.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.37624226.0
 
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.