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

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

73 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
smoothies145613(None) 
smoothes13218541smooth_es
smoothie1344891smoothie_
smithies1337912sm_ithies
smooches15217262smooch_es
smooshes13206862smoosh_es
smoothed14236472smooth_ed
smoothen13204962smooth_en
smoothens14194252smoothens
smoother13196672smooth_er
smoothers14206042smoothers
smoothest14215772smooth_est
smoothing1535292smoothing
smoothness1543042smoothness
smooths12216322smooth__s
soothes103917112s_ooth_es
booties94124613_boot_ies
bothies12414783__bothies
cooties93725733_coot_ies
dhooties1237643dhoot_ies
empathies16115403empathies
footies103721543_foot_ies
footsies1139643_footsies
hoochies1639603_hoochies
monthlies1446513_monthlies
mooches143714453_mooch_es
mothier121910213_m_othier
mothiest13311033_m_othiest
mouthier13208173_mouthier
mouthiest1438363_mouthiest
scooches15188413scooch_es
scootches1635003scootches
scotties1039753s_cotties
shooflies1544143shooflies
shorties11414583short_ies
smarties10312873smart_ies
smooched16185983smooch_ed
smoocher15205503smooch_er
smoochers16184833smoochers
smooching1734883smooching
smooshed14185993smoosh_ed
smooshing1534793smooshing
smooth11259203smooth___
smoothbores1851333smoothbores
smoothened1642483smoothened
smoothly16203643smooth_ly
smoothy15205083smooth__y
smother123510213sm_oth_er
smothers13349933sm_others
snootier8278383snoot_ier
snootiest9178753snoot_iest
softies103414613s_oft_ies
soothe94214853s_ooth_e_
soothed113712743s_ooth_ed
soother104215043s_ooth_er
soothers113913433s_oothers
soothest113312243s_ooth_est
soothing12269973s_oothing
sooths95715593s_ooth__s
sootier73916613s_oot_ier
sootiest84016753s_oot_iest
sophies12314613s__ophies
sorties74126403s_ort_ies
spoonies101911753spoo_nies
stithies1139233s_tithies
stoolies8311083stoo_lies
swooshes14185123swoosh_es
sympathies2054583sympathies
timothies1444713timothies
toothier1136423_toothier
toothiest1237523_toothiest
tootsies848613_tootsies
worthies14310283_worthies

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.1531167915.0
2DLD Change Limit148641737.36020195.8
3Display Results73730.0332212.1
 (SQL Overall)178691737.54623680.2
 
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.