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

96 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
unblocked186435(None) 
unlocked15268381un_locked
blocked16449982__blocked
unbacked17268732unb_acked
unblock1545792unblock__
unblocks1644522unblock_s
unblooded1343842unblooded
uncloaked1635652uncloaked
uncocked17248752un_cocked
undocked16277632un_docked
unfrocked1944222unfrocked
unlicked15248262un_licked
unplucked1843572unplucked
unstocked1645062unstocked
blacked163613373__blacked
blocker15419923__blocker
clocked164112833__clocked
flocked174510253__flocked
hillocked1942793hillocked
knocked13236303kn__ocked
landlocked1851813landlocked
locked134921663___locked
nocked134617383_n__ocked
padlocked1942433padlocked
relocked15217743_relocked
shylocked2242203shylocked
sunblock1643763sunblock__
sunblocks1743413sunblock_s
unbaked143312893unb__aked
unbeloved1543923unbelo_ved
unblamed1337193unbl_amed
unbleached1842763unbleached
unblenched1842563unblenched
unblended13265853unblended
unblessed1245323unblessed
unblinded13295233unblinded
unblocking1943693unblocking
unblurred1243003unblurred
unbobbed1234413unb_obbed
unbodied1237263unb_odied
unboiled112410373unb_oiled
unbolted1179323unb_olted
unbonded12299763unb_onded
unboned103014223unb_o_ned
unbooted1188773unb_ooted
unbowed132610243unb_o_wed
unboxed17249573unb_o_xed
unbraced132310433unbrac_ed
unbraked15289413unb_raked
unbroiled1235803unbroiled
unbroke13217743unbro_ke_
unbroken14235073unbro_ken
unbrowned1554053unbrowned
unbuckled1843633unb_uckled
unchecked2144063unchecked
unchoked18257623uncho_ked
uncliched1744623uncliched
unclogged1443933unclogged
unclosed111010503unclo_sed
unclothed1545433unclothed
unclouded1345333unclouded
uncloyed1487343unclo_yed
uncooked15269113un_cooked
uncorked152210403un_corked
uncracked18226803uncracked
undecked16238493un_decked
unelected1237823unelected
unforked16218953un_forked
unglossed1144133unglossed
ungloved1335603unglo_ved
unhooked16286743un_hooked
unilobed1136393unilo_bed
unlaced102913733un_lac_ed
unliked122411283un_l_iked
unlinked13237793un_linked
unloaded1049533un_loaded
unlobed10219743un_lo_bed
unlocated1238383un_located
unlock1248533un_lock__
unlocks1337063un_lock_s
unloosed9117523un_loosed
unloved112310533un_lo_ved
unpacked17268663un_packed
unpicked17237213un_picked
unplaced1338613unplac_ed
unplowed1436353unplo_wed
unslaked1338463unsl_aked
unsliced1138093unslic_ed
unsmoked1536013unsmo_ked
unsoaked1338853un_soaked
unstacked1636433unstacked
untacked15239923un_tacked
untracked16228373untracked
untucked15206053un_tucked
unworked16238503un_worked
unyoked1567123un_yo_ked

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.436409841.7
2DLD Change Limit148641967.34320242.5
3Display Results96960.0462087.0
 (SQL Overall)178691967.82522835.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.