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

77 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
unsoothed134425(None) 
unsmoothed1642001unsmoothed
besoothed1543662besoothed
soothed113712742__soothed
unbooted1188772unboot_ed
unclothed1545432unclothed
unrooted9810512unroot_ed
unscathed1535312unscathed
unsorted9312512unsort_ed
unspotted1244932unspotted
unswathed1634542unswathed
besmoothed1842403besmoothed
besoothe1343783besoothe_
besoothes1443763besoothes
enrooted977423enroot_ed
enswathed1642763enswathed
inswathed1642963inswathed
resmoothed1642563resmoothed
smoothed14236473_smoothed
snooted84213283sn_oot_ed
sooted73922593__soot_ed
soothe94214853__soothe_
soother104215043__soother
soothes103917113__soothes
southed114313993__southed
toothed113310243__toothed
unbathed1437223un_bathed
unbolted1179323unbolt_ed
unbottled1244153unbottled
unclothe1345703unclothe_
unclothes1445143unclothes
uncoated11314963uncoat_ed
uncooked15269113uncoo_ked
uncooled112710633uncoo_led
undotted1048523un_dotted
unearthed1345573unearthed
unhooded13277873unhoo_ded
unhooked16286743unhoo_ked
unknotted1443623unknotted
unloosed9117523unloo_sed
unmoored1137333unmoo_red
unnoted8311363un_not_ed
unposted1159433unpost_ed
unpotted11108393un_potted
unquoted1836533unquot_ed
unroofed12106773unroo_fed
unsalted9510923unsalt_ed
unsated83419933uns_at_ed
unseated91317683unseat_ed
unsettled1055213unsettled
unsheathed17174133unsheathed
unshed10313773uns___hed
unsifted12128773unsift_ed
unsighted1455433unsighted
unsmoked1536013unsmo_ked
unsoaked1338853uns_oaked
unsoiled92412083uns_oiled
unsolved1237833uns_olved
unsounded1135543unsounded
unsourced1244833unsourced
unsoured9310063uns_oured
unsowed112511053uns_o_wed
unspoiled12255563unspoiled
unspooled12254913unspooled
unstated91615813unstat_ed
unstitched1643513unstitched
unstocked1645063unstocked
unstoned9311043unsto_ned
unstopped1444403unstopped
unsuited9310793unsuit_ed
unswathe1444603unswathe_
unswathes1544213unswathes
untouched1544413untouched
unwonted12248643unwont_ed
unwooded13207443unwoo_ded
unwooed11229773unwoo__ed
uprooted1186393uproot_ed

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.420425454.8
2DLD Change Limit148641777.17320722.3
3Display Results77770.0302566.7
 (SQL Overall)178691777.62323441.0
 
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.