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 “besmoothing” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
besmoothing1912200(None) 
besoothing1693161bes_oothing
resmoothing17122591resmoothing
smoothing1535292__smoothing
badmouthing2051213badmouthing
beclothing1843873be_clothing
bescorching2142283bescorching
beshouting1644023beshout_ing
besmirching2191913besmirching
besmoking18114613besm_o_king
besmooth1543353besmooth___
besmoothed1842403besmooth_ed
besmooths1642593besmooth__s
besmutting1553353besm_utting
besotting12256873bes__otting
betrothing1644663be_trothing
reshooting1436223reshoot_ing
smooching1734883__smooching
smooshing1534793__smooshing
soothing12269973__s_oothing
beblooding1643244bebloo_ding
befooling1535054be_foo_ling
beglooming1642954begloo_ming
behooving1843744be_hoo_ving
beknotting1782814be_knotting
bemisting1438074be_mist_ing
bemoaning1435954be_m_oaning
bemocking2034654be_m_ocking
bequeathing2651574bequeathing
berthing14209594be___rthing
bescouring1584644bes_couring
beseeching1843364bes_eeching
besetting12268424bes__etting
beshrouding1852234beshrouding
besmearing1544324besm_earing
besmiling1436264besm__iling
besmudging1782124besm_udging
besnowing1544124bes_no_wing
besoothe1343784bes_ooth__e
besoothed1543664bes_ooth_ed
besoothes1443764bes_ooth_es
bespousing1553414bes_pousing
besting104923924bes___t_ing
bestowing1535804bes_to_wing
bestrowing1644374bestro_wing
bevomiting1843104bevomit_ing
bigfooting1741914bigfoot_ing
booting103821364b___oot_ing
demoting12311424de_m_ot_ing
disrooting1247744disroot_ing
emoting10313564_e_m_ot_ing
enrooting10128134_enroot_ing
escorting1237714_escort_ing
escoting1158714_es_cot_ing
festooning1444494festoo_ning
mooching16259064___mooching
mooting103019364___moot_ing
mouthing142810244___mouthing
rebooting12139024re_boot_ing
reclothing1644974re_clothing
resmelting1337264resmelt_ing
resmooth1343634resmooth___
resmoothed1642564resmooth_ed
resmooths1442644resmooth__s
resorting10614614res_ort_ing
respooling1355744respoo_ling
respotting1347114res_potting
scooching1735074__scooching
scootching1843364__scootching
scooting113012644__scoot_ing
shooting122812864__shoot_ing
smoothen13204964__smoothen_
smoothening1752114__smoothening
smoothens14194254__smoothens
smoothie1344894__smoothi_e
smoothies1456134__smoothies
snooting92813204__snoot_ing
something1545404__something
sooting82820964__s_oot_ing
southing122811824__s_outhing
swooshing1643884__swooshing
toothing12278864___toothing
upshooting1642554upshoot_ing

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 Filter1786911488190.423422437.4
2DLD Change Limit148819838.42317668.2
3Display Results83830.0302766.7
 (SQL Overall)178691838.87620131.9
 
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.