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

111 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
unscathed153531(None) 
unswathed1634541unswathed
enswathed1642762enswathed
inswathed1642962inswathed
scathed134012642__scathed
unbathed1437222un_bathed
uncashed14299762un_cashed
unsated83419932uns_at_ed
unscaled111410112unsca_led
unscanned1245132unscanned
unscarred1235672unscarred
unseated91317682unseat_ed
unsheathed17174132unsheathed
unsoothed1344252unsoothed
unstated91615812unstat_ed
unswathe1444602unswathe_
unswathes1544212unswathes
ansated84214003ans_at_ed
encashed14246473en_cashed
ensheathed17162983ensheathed
enswathe1443153enswathe_
enswathes1543433enswathes
insheathed17173073insheathed
instated91613343instat_ed
inswathe1443693inswathe_
inswathes1543953inswathes
scathe114414993__scathe_
scathes124515713__scathes
scatted103512773__scatted
scythed16385303__scythed
spathed134013183__spathed
sunbathed1543313sun_bathed
swathed144611933__swathed
tunicated12257493tunicat_ed
unabashed1544103unabashed
unabated11310133unabat_ed
unacted10312733unac_t_ed
unbated103317733un_bat_ed
uncaged113314123un_ca_ged
uncaked143514353un_ca_ked
uncalled11810923un_called
uncanned11289963un_canned
uncapped1556693un_capped
uncarded12310133un_carded
uncarted11312053un_carted
uncarved1438163un_carved
uncased104216953un_ca_sed
uncasked15278453un_casked
uncatered1237403un_catered
uncaused1138453un_caused
unclothed1545433unclothed
uncoated11314963uncoat_ed
uncrated11416313uncrat_ed
undated93118463un_dat_ed
unearthed1345573unearthed
ungated92717213un_gat_ed
unhatched1844133un_hatched
unhatted1238183un_hatted
unheated121514553unheat_ed
unlashed12289183un_lashed
unlatched1544223un_latched
unleashed1345403unleashed
unlocated1238383unlocat_ed
unmatched1744203un_matched
unmated103317023un_mat_ed
unmatted1138293un_matted
unpatched1744053un_patched
unrated82621553un_rat_ed
unreached1536883unreached
unsalted9510923uns_alted
unsaved113312193uns_a_ved
unsawed112911503uns_a_wed
unscented1237513unscented
unscrewed1554033unscrewed
unsealed91513623unsea_led
unseamed111210663unsea_med
unseared91113943unsea_red
unsettled1055213unsettled
unshaded13149263unsha_ded
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unsheathe15174753unsheathe_
unsheathes16183843unsheathes
unshed10313773uns___hed
unsifted12128773unsift_ed
unsighted1455433unsighted
unslaked1338463unsla_ked
unsmoothed1642003unsmoothed
unsnagged1243123unsnagged
unsnapped1443983unsnapped
unsnarled1035743unsnarled
unsoaked1338853unsoa_ked
unsorted9312513unsort_ed
unspotted1244933unspotted
unstacked1636433unstacked
unstained1038683unstained
unstalked1435523unstalked
unstamped1454603unstamped
unstarred1036363unstarred
unstate71916213unstat_e_
unstates81314993unstat_es
unstayed12168393unsta_yed
unstitched1643513unstitched
unsuited9310793unsuit_ed
unswayed15155713unswa_yed
unwashed15288483un_washed
unwatched1844083un_watched
unwreathed1763683unwreathed
upscaled13144873upsca_led

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.423422437.4
2DLD Change Limit1486411116.90621523.5
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.37524229.3
 
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.