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

92 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
unearthed134557(None) 
inearthed1343621inearthed
earthed1139922__earthed
unarched14128552un_arched
unbathed1437222unba_thed
uncarted11312052uncart_ed
unearned9310062unear_ned
unearth1037062unearth__
unearthly1543152unearthly
unearths1144352unearth_s
unparted11310822unpart_ed
aneared8512743anear__ed
berthed13259123_be_rthed
breathed14469643brea_thed
cuneated11310103cunea_t_ed
earthen1039253__earthen
hearted113314023_heart_ed
inarched1486113in_arched
inearth1037043inearth__
inearths1144933inearth_s
narthex1734263_n_arthex
neared75119803_near__ed
neatherd12107193_nea_therd
searched14209253_searched
sheathed1547223shea_thed
sunbathed1543313sunba_thed
unacted10312733un_act_ed
unargued1035583un_argued
unarmed101811923un_ar_med
unbarbed13217753unbar_bed
unbarred11238703unbar_red
unbasted112510073unbast_ed
unbated103317733unba_t_ed
unbearded13146343unbear_ded
unbeared111611653unbear__ed
uncarded12310133uncar_ded
uncarved1438163uncar_ved
uncashed14299763unca_shed
uncharted1538083unchart_ed
unclothed1545433unclothed
uncrated11416313uncrat_ed
undated93118463unda_t_ed
unearthing1454373unearthing
unearthlier1451823unearthlier
uneaten7412543unea_t_en
unedited10249833unedit_ed
unenriched1642563unenriched
unerased9312773une_rased
unexalted1744333unexalt_ed
unfeared121511013unfear__ed
ungarbed12197063ungar_bed
ungated92717213unga_t_ed
unharmed1438093unhar_med
unharried1344763unharried
unhatched1844133unhatched
unhatted1238183unha_tted
unheated121514553unhea_t_ed
unlashed12289183unla_shed
unlatched1544213unlatched
unlearned1035653unlear_ned
unleashed1345403unlea_shed
unmarked15248813unmar_ked
unmarred11258403unmar_red
unmarried1244583unmarried
unmatched1744203unmatched
unmated103317023unma_t_ed
unmatted1138293unma_tted
unpatched1744053unpatched
unrated82621553unra_t_ed
unreached1536883unrea_ched
unsalted9510923unsalt_ed
unsated83419933unsa_t_ed
unscathed1535313unscathed
unseared91113943unsear__ed
unseated91317683unsea_t_ed
unsheathed17174133unshea_thed
unsoothed1344253unsoothed
unsorted9312513unsort_ed
unswathed1634543unswathed
untasted92011573untast_ed
unvaried1239683unvar_ied
unwanted12249603unwant_ed
unwarmed1437303unwar_med
unwarned1238453unwar_ned
unwarped1436873unwar_ped
unwashed15288483unwa_shed
unwasted12259783unwast_ed
unwatched1844083unwatched
unwearied1336763unwear_ied
unwreathed1763683unwrea_thed
updarted1244313updart_ed
wreathed15257463wrea_thed

Search took 7 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 Limit148641926.31323545.2
3Display Results92920.0303066.7
 (SQL Overall)178691926.76326421.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.