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

134 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
uncleared123754(None) 
uncleaned1237171uncleaned
unclearer1144621unclearer
cleared103612462__cleared
nucleated1247872nucleated
unbeared111611652un_beared
unclawed1457982uncl_awed
uncleaner1144762uncleaner
unclear936572unclear__
unclearest12113822unclearest
unclearly1444292unclearly
uncloaked1635652uncloaked
uncreated12312302uncreated
unfeared121511012un_feared
unleaded10411332un_leaded
unlearned1035652un_learned
unleased9310712un_leased
unpleased1236082unpleased
unseared91113942un_seared
aneared8512743an__eared
antlered938263antle_red
bleared104211253__bleared
cleaned103512003__cleaned
clearer93710823__clearer
cleated103417843__cleated
cleaved134010483__cleaved
declared1248743decl_ared
enclaved1456343encl_aved
endeared1038053en_deared
enucleated1345123enucleated
increased1245533increased
misleared1277453misleared
neared75119803_n__eared
nuclear936233nuclear__
nuclease1046213nuclease_
nucleases1146493nucleases
nucleate1048673nucleate_
nucleates1148563nucleates
precleared1544113precleared
recleaned1236583recleaned
ulcered1037973ulc_e_red
unalarmed1244633unal_armed
unalerted1047963unalerted
unallayed1344073unallayed
unaltered1037723unaltered
unbearded13146343un_bearded
unblamed1337193unbl_amed
unbleached1842763unbleached
unblended13265853unblended
unblessed1245323unblessed
unblurred1243003unblurred
uncaged113314123unc__aged
uncaked143514353unc__aked
uncarded12310133unc__arded
uncarted11312053unc__arted
uncarved1438163unc__arved
uncased104216953unc__ased
uncatered1237403uncatered
unceded11410563unc_e_ded
unchaired1536203unchaired
uncharged1636613unc_harged
uncharred1536103uncharred
uncharted1538083unc_harted
unchecked2144063unchecked
unchewed1735803unche_wed
unciliated1348053unciliated
unclad938913uncl_a__d
unclaimed1435793unclaimed
unclamped1664503unclamped
unclasped1465503unclasped
unclean946973unclea__n
uncleanest12105663uncleanest
uncleanly1444183uncleanly
unclenched1843353unclenched
uncliched1744623uncliched
unclipped1643843unclipped
unclogged1443933unclogged
unclosed111010503uncl_osed
unclothed1545433unclothed
unclouded1345333unclouded
uncloyed1487343uncl_oyed
uncoated11314963unc_oated
uncoerced1445313uncoerced
uncolored1246963uncolored
uncovered1546613uncovered
uncrated11416313unc_rated
uncreate10311353uncreate_
uncreates11310433uncreates
uncrewed1456763uncre_wed
uncultured1344673uncultured
uncured10513233unc__ured
undeclared1445043undecl_ared
undreamed1336973undreamed
unearned9310063un__earned
unelected1237823unelected
unflawed1536123unfl_awed
unfledged1543563unfledged
unflexed1935263unfle_xed
unglazed1936263ungl_azed
ungreased1136333ungreased
unhealed121511073un_healed
unheard1136943un_hear_d
unheated121514553un_heated
unideaed1045733unidea_ed
unlaced102913733un_l_aced
unladed92614373un_l_aded
unlead73312373un_lea__d
unleadeds1143943un_leadeds
unlearn735953un_lear_n
unlearns844453un_learns
unlearnt846403un_learnt
unleashed1345403un_leashed
unletted9310313un_letted
unlevied1236843un_levied
unloaded1049533un_loaded
unplaced1338613unpl_aced
unplayed1437263unpl_ayed
unpledged1443843unpledged
unprepared1543023unprepared
unrelated10310433unrelated
unrelaxed1744463unrelaxed
unsealed91513623un_sealed
unseamed111210663un_seamed
unseated91317683un_seated
unshared121510703un_shared
unslaked1338463unsl_aked
unsquared1944073unsquared
untreaded1137983untreaded
untreated10312903untreated
unweaned1238593un_weaned
unwearied1336763un_wearied
unyeaned1237743un_yeaned
upleaped1334333u_pleaped
upreared1137073u_preared

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 Limit1486411346.61022487.3
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.09325192.6
 
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.