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

104 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
unclean94697(None) 
unclear936571unclear
clean75420412__clean
nucleal946692nucleal
nuclear936232nuclear
nuclein966122nuclein
nucleon945552nucleon
reclean938522reclean
unclad938912uncl_ad
uncle7317052uncle__
uncleaned1237172uncleaned
uncleaner1144762uncleaner
uncleanly1444182uncleanly
uncleft1257492uncleft
uncles8317162uncle_s
uncloak1365472uncloak
unlead73312372un_lead
unlearn735952un_learn
archean1269123archean
bioclean1243153bioclean
clan65633923__cl_an
cleans85817053__cleans
clear76219053__clear
cleat76335063__cleat
endleaf1145223endleaf
glean65818203__glean
lactean956473lactean
lean46345243___lean
luncheon1344013luncheon
lyncean1292923lync_ean
muscleman1592523muscleman
nuclease1046213nuclease
nucleate1048673nucleate
nuclei857723nucle_i
nucleins1046083nucleins
nucleons1065483nucleons
nucleus956573nucleus
nuncle839363nuncle__
nuncles939843nuncle_s
ocean71212963_oc_ean
preclean1245893preclean
puncheon1544473puncheon
recleans1037513recleans
spelean937123spelean
subclan1147173subcl_an
uhlan849113u_hl_an
ulan46527393u__l_an
ulpan7310123u__lpan
unban72114333un__ban
unbear889163un_bear
unblest9411813unblest
uncap9312283unc__ap
unchain1238943unchain
uncia75015163unc_ia_
unciae83215313unc_iae
uncial83715223unc_ial
uncinal959963uncinal
unclamp1344993unclamp
unclasp1135963unclasp
uncleanest12105663uncleanest
uncleared1237543uncleared
unclearer1144623unclearer
unclearly1444293unclearly
unclench1544143unclench
unclip1046993uncl_ip
unclips1136433unclips
uncloaks1444133uncloaks
unclog956603uncl_og
unclogs1036803unclogs
unclose91111643unclose
uncloud1046433uncloud
uncreate10311353uncreate
uncrown1236323uncrown
unction9310663unction
undead82711903un_dead
uneven957913uneve_n
unhewn12285253un_hewn
unhuman1264173unhuman
unideal837103unideal
unlay84613703un_l_ay
unleads8228623un_leads
unlearns844453un_learns
unlearnt846403un_learnt
unleash1034963un_leash
unled64021073un_le_d
unless62413073un_less
unlet54133333un_le_t
unload73010803un_load
unman72715423un__man
unmeant9510903un_meant
unopen838913unope_n
unpen72913573un_pe_n
unpliant1047143unpliant
unread73412673un_read
unreal64414453un_real
unseal63315473un_seal
unseam83313143un_seam
unseat64221023un_seat
unseen62012623un_seen
unsewn9298393un_sewn
unspeak1344793unspeak
unswear1035003unswear
untread857413untread
upleap10106843u_pleap

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271046.90619407.3
3Display Results1041040.0432418.6
 (SQL Overall)1786911047.34224338.2
 
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.