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

115 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
unclear93657(None) 
nuclear936231nuclear
unclean946971unclean
clear76219052__clear
nucleal946692nucleal
unbear889162un_bear
unclad938912uncl_ad
uncle7317052uncle__
uncleaner1144762uncleaner
uncleared1237542uncleared
unclearer1144622unclearer
unclearly1444292unclearly
uncleft1257492uncleft
uncles8317162uncle_s
uncloak1365472uncloak
unlead73312372un_lead
unlearn735952un_learn
unswear1035002unswear
anear55420323an__ear
angler74017863angle_r
antbear935063antbear
antler64615553antle_r
binuclear1382003binuclear
blear75918683__blear
bundler104011723bundle_r
bungler104611483bungle_r
clean75420413__clean
clears84116563__clears
cleat76335063__cleat
cochlear1543593cochlear
cyclecar1442703cyclecar
cycler1335913cycle_r
endear74110013en_dear
endleaf1145223endleaf
incher114114033inche_r
lear47045953___lear
luncher123111413lunche_r
lunular736013lunul_ar
muncher143610373munche_r
near45236503_n__ear
nucellar1044333nucellar
nuclease1046213nuclease
nucleate1048673nucleate
nucleator1144873nucleator
nuclei857723nucle_i
nuclein966123nuclein
nucleolar1183033nucleolar
nucleon945553nucleon
nucleus956573nucleus
nuncle839363nuncle__
nuncles939843nuncle_s
preclear1245423preclear
puncher143311673punche_r
reclean938523reclean
sclera838883_sclera
subnuclear1451883subnuclear
ulcer7310753ulc_e_r
ulnar56013983u__lnar
unbar71913613un__bar
unbears998043un_bears
unblest9411813unblest
uncap9312283unc__ap
unchair1236163unchair
unchary1537263unc_hary
uncia75015163unc_ia_
unciae83215313unc_iae
uncial83715223unc_ial
uncinal959963uncinal
unclamp1344993unclamp
unclasp1135963unclasp
uncleaned1237173uncleaned
uncleanly1444183uncleanly
unclearest12113823unclearest
unclench1544143unclench
unclip1046993uncl_ip
unclips1136433unclips
uncloaks1444133uncloaks
unclog956603uncl_og
unclogs1036803unclogs
unclose91111643unclose
uncloud1046433uncloud
uncover1239003uncover
uncreate10311353uncreate
undead82711903un_dead
under64624213un_de_r
undoer73113043undoe_r
undular837123undular
ungular836773ungular
unheard1136943un_heard
unideal837103unideal
unilinear942913unilinear
uniter64619143unite_r
unlay84613703un_l_ay
unleads8228623un_leads
unlearns844453un_learns
unlearnt846403un_learnt
unleash1034963un_leash
unled64021073un_le_d
unless62413073un_less
unlet54133333un_le_t
unload73010803un_load
unread73412673un_read
unreal64414453un_real
unseal63315473un_seal
unseam83313143un_seam
unseat64221023un_seat
unspeak1344793unspeak
unswears1144023unswears
untread857413untread
unweary1335843un_weary
upbear1096493u_pbear
upleap10106843u_pleap
uprear8168793u_prear
uptear896783u_ptear
uvular955563uvul_ar

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271156.75019855.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.95225703.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.