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

103 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
smoochers1618483(None) 
moochers15369121_moochers
smoocher15205501smoocher_
smooches15217261smooche_s
smoothers14206041smoothers
moocher143610672_moocher_
mooches143714452_mooche_s
scooches15188412scooche_s
scorchers16145512scorchers
slouchers14185622slouchers
smooched16185982smooche_d
smooshes13206862smooshe_s
smoothens14194252smoothens
smoother13196672smoother_
smoothes13218542smoothe_s
smothers13349932sm_others
soothers113913432s_oothers
avouchers1743083avouchers
botchers153511543_botchers
broachers16328153broachers
brooches15288193brooche_s
coachers154312303_coachers
cooches143515833_cooche_s
couchers153513863_couchers
hooches153812523_hooche_s
marchers153710813_marchers
matchers153012433_matchers
mockers153812943_m_ockers
mooched153910533_mooche_d
mooners94015343_moo_ners
moorhens1344853_moorhens
mooters93818623_moo_ters
moshers124017843_m_oshers
mothers123717623_m_others
mouches143815963_mouche_s
mouthers133811303_mouthers
munchers15318773_munchers
notchers13279423_notchers
ochers113915303___ochers
poachers152910763_poachers
pooches143214163_pooche_s
scooched16206683scooche_d
scoopers124210193scoo_pers
scootches1635003scootche_s
scooters103511033scoo_ters
scorcher15196783scorcher_
scorches15189143scorche_s
scotches15179473scotche_s
scouthers1445993scouthers
scrooches1645703scrooche_s
scutchers16175643scutchers
searchers14197353searchers
shockers17319463s_hockers
shooters112811583shoo_ters
sketchers1834513sketchers
sloucher13206813sloucher_
slouches13208073slouche_s
smackers16318713sm_ackers
smashers13339593sm_ashers
smirches1535993smirche_s
smithers13369793sm_ithers
smokers13389323sm_o_kers
smolders11287193sm_olders
smooch13266803smooch___
smooching1734883smooching
smoochy17223863smooch__y
smooshed14185993smooshe_d
smoothed14236473smoothe_d
smoothen13204963smoothe_n
smoothest14215773smoothest
smoothies1456133smoothies
smoothness1543043smoothness
smooths12216323smooth__s
smother123510213sm_other_
smothery16296063sm_othery
smoulders1243143smoulders
smutches15177273smutche_s
snatchers14146313snatchers
snitchers14166043snitchers
snookers12398653snoo_kers
snoopers10319843snoo_pers
snoozers17296943snoo_zers
soccers1138393s__occers
sooners73916643s_oo_ners
soother104215043s_oother_
soothes103917113s_oothe_s
soroches1338803soroche_s
southers114214453s_outhers
spoofers13307323spoo_fers
spoolers10349363spoo_lers
stanchers14206813stanchers
stitchers14147013stitchers
stockers143411073s_tockers
stomachers1783893stomachers
stookers12449793stoo_kers
stoopers103711303stoo_pers
switchers17146633switchers
swooners11336863swoo_ners
swoopers13317523swoo_pers
swooshes14185123swooshe_s
tochers123413093__tochers
touchers133611213_touchers
vouchers16418623_vouchers

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411037.26620457.1
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.46823927.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.