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

68 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
undoubted134446(None) 
undoubled1344231undoubled
doubted11307482__doubted
uncounted1238522uncounted
undaunted1145452undaunted
undotted1048522undo_tted
undouble1145442undouble_
undoubles1243922undoubles
undoubtedly1851502undoubtedly
undubbed1443522und_ubbed
unmounted1245902unmounted
doubled11289953__doubled
doubter10298353__doubter
indebted12246873ind_ebted
inducted1237273ind_ucted
knouted12416773kn_ou_ted
misdoubted1642553misdoubted
redoubled1343773redoubled
snouted84311343sn_ou_ted
unadjusted1942493unadjusted
unadopted1344563unado_pted
unbobbed1234413unbo_bbed
unbolted1179323unbo_lted
unbooted1188773unbo_oted
unbounded1335413unbounded
unbusted11258773un_busted
uncoated11314963unco_ated
uncobbled1643663uncobbled
uncombed1536323uncomb_ed
uncoupled1445703uncoupled
undated93118463und__ated
undebated1338093undebated
undeleted1148063undeleted
undented102313953und_ented
underbred1338993underbred
undiluted1144903undiluted
undoable1139053undoable_
undocked16277633undo_cked
undoubting14103333undoubting
undulated11310083undulated
undulled1036993und_ulled
unfluted1237173unflu_ted
unfounded1435363unfounded
unhoused1238153unhou_sed
unjointed1755583unjointed
unlobed10219743unlo_b_ed
unlocated1238383unlocated
unmourned1254153unmourned
unnoted8311363unno__ted
unpointed1237153unpointed
unposted1159433unpo_sted
unpotted11108393unpo_tted
unquoted1836533un_quoted
unroasted1036613unroasted
unrobed102711213unro_b_ed
unrooted9810513unro_oted
unrounded1135863unrounded
unrusted92310353un_rusted
unsorted9312513unso_rted
unsounded1135543unsounded
unsourced1244833unsourced
unsoured9310063unsou_red
unsuited9310793un_suited
untouched1544413untouched
untroubled1342503untroubled
untufted1236083un_tufted
unwonted12248643unwo_nted
unwounded1444623unwounded

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 Limit148641686.89021573.4
3Display Results68680.0332060.6
 (SQL Overall)178691687.34624324.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.