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

123 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
smooching173488(None) 
mooching16259061_mooching
scooching1735071scooching
smooshing1534791smooshing
smoothing1535291smoothing
mouching163110582_mouching
pooching16328982_pooching
scootching1843362scootching
scorching1735632scorching
scotching1735652scotching
scrooching1843322scrooching
slouching15195722slouching
smirching1744392smirching
smocking17349102sm_ocking
smutching1734852smutching
soochong14104372s_oochong
soothing12269972s_oothing
swooshing1643882swooshing
avouching1843273avouching
besmoothing19122003besmoothing
blotching1734963blotching
botching16359703_botching
broaching17287663broaching
coaching164011963_coaching
couching163213263_couching
crouching1746383crouching
douching15349843_douching
grouching1644943grouching
hotching17309313_hotching
marching164312193_marching
matching163512393_matching
miching152911803_m_iching
mocking163614453_m_ocking
mooing93718373_moo__ing
mooning103415553_moo_ning
mooring102514443_moo_ring
mooting103019363_moo_ting
morphing1637553_morphing
moshing134214883_m_oshing
mouthing142810243_mouthing
mulching16287103_mulching
munching16299973_munching
notching14288583_notching
oohing104412933__oo_hing
ouching134314903__ouching
poaching163510833_poaching
poohing133112323_poo_hing
pouching163210413_pouching
resmoothing17122593resmoothing
roaching143210433_roaching
sconcing1338263sconc_ing
scooping133610633scoo_ping
scooting113012643scoo_ting
scrootching1951893scrootching
scutching1735223scutching
searching1538343searching
shmoozing2443613shmoo_zing
shocking184311543s_hocking
shooing112112913shoo__ing
shooling123012563shoo_ling
shooting122812863shoo_ting
sketching1935083sketching
sloshing12258823s_loshing
sloughing14244753sloughing
smacking173510763sm_acking
smashing143310243sm_ashing
smockings18264283sm_ockings
smoking143210523sm_o_king
smooch13266803smooch___
smooched16185983smooch_ed
smoocher15205503smooch_er
smoochers16184833smoochers
smooches15217263smooch_es
smoochy17223863smooch__y
smoothen13204963smoothen_
smoothening1752113smoothening
smoothens14194253smoothens
smoothie1344893smoothi_e
smoothies1456133smoothies
smushing14287453sm_ushing
snatching1536363snatching
snitching1535913snitching
snooding102910433snoo_ding
snooking133010583snoo_king
snooling93013473snoo_ling
snooping113811323snoo_ping
snooting92813203snoo_ting
snoozing18319083snoo_zing
snoozling19314343snoozling
socking143518603s__ocking
something1545403something
soochongs1583143s_oochongs
sooting82820963s_oo_ting
souchong1484513s_ouchong
soughing13259733s_oughing
southing122811823s_outhing
sploshing1544293sploshing
splotching1842863splotching
spoofing14228363spoo_fing
spooking15269803spoo_king
spooling113212563spoo_ling
spooning112811443spoo_ning
spooring113111463spoo_ring
squooshing2341993squooshing
stanching1538083stanching
starching1538593starching
stitching1547103stitching
stocking152912503s_tocking
stomaching1844313stomaching
stooging102810043stoo_ging
stooking132711143stoo_king
stooling93113133stoo_ling
stooping113012363stoo_ping
switching1835703switching
swooning12278203swoo_ning
swooping14338403swoo_ping
synching17227713s_ynching
toothing12278863_toothing
torching142510083_torching
touching143211343_touching
vouching17308233_vouching
whooshing1943213whooshing
wooshing1536683_wooshing

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.436409841.7
2DLD Change Limit1486411237.25020502.2
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.