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

200 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
unladen824865(None) 
unlade72714151unlade_
unladed92614371unladed
unlades82612831unlades
anlagen8238642anlagen
laden65022192__laden
uneaten7412542uneaten
unfaded123111732unfaded
unjaded16279142unjaded
unlace82215172unlace_
unlaced102913732unlaced
unlaces92513622unlaces
unlading1058862unlading
unleaded10411332unleaded
unloaded1049532unloaded
unloader936642unloader
unmade92911062unmade_
untaken1137642untaken
anadem939183an_adem
anlace82513923anlace_
anlaces92313733anlaces
anlage72514233anlage_
anlages82414113anlages
anlases72514903anlases
blade85923333_blade_
bladed104717763_bladed
blader93618583_blader
blades95221253_blades
broaden10289143broaden
celadon1036913celadon
clade85821013_clade_
clades94920463_clades
deaden83714323_deaden
enlace82213233enlace_
enlaced102410523enlaced
enlaces92313393enlaces
enliven1034903enliven
flamen115215993_flamen
flaxen16518573_flaxen
gladden10376313_gladden
glade75121963_glade_
glades84820343_glades
golden84411153gol_den
gulden8328763gul_den
holden104113953hol_den
inlace82513043inlace_
inlaced10239873inlaced
inlaces92512903inlaces
inlander937223inlander
inlayer1036933inlayer
invade10157853invade_
invaded12127043invaded
invader11146453invader
invades11118293invades
kneaded13146473kneaded
kneader1275893kneader
lade56345983__lade_
laded74232613__laded
ladens74516233__ladens
lader65633723__lader
lades65141273__lades
laten54328343__laten
leaden74515223_leaden
loden66621143__loden
menhaden1444213menhaden
milden94113153mil_den
neaten64214543_neaten
olden65114853_ol_den
onloaded1044743onloaded
paladin101011773paladin
platen84518203_platen
uhlan849113uhla__n
ulan46527393u_la__n
ullage739043ullage_
ullaged937033ullaged
ullages838953ullages
ulnad65611453ulnad__
ulnae55214573ulna_e_
unadded10238523unadded
unadept1046603un_adept
unaged83916423un_aged
unaided92414603unaided
unakin10310963un_akin
unawed103914903un_awed
unaxed144113093un_axed
unbaked143312893unbaked
unbale83616403unbale_
unbaled103315963unbaled
unbales92914863unbales
unban72114333unba__n
unbanded123010563unbanded
unbased103513483unbased
unbated103317733unbated
unbeaten1038013unbeaten
unbidden1263573unbidden
unblamed1337193unblamed
unburden11124293unburden
uncage93014873uncage_
uncaged113314123uncaged
uncages103213773uncages
uncake122813523uncake_
uncaked143514353uncaked
uncakes133012743uncakes
uncarded12310133uncarded
uncase83817433uncase_
uncased104216953uncased
uncases93516553uncases
unceded11410563unceded
unclad938913unclad__
unclawed1457983unclawed
uncoded11312743uncoded
undated93118463undated
unde55825483un__de_
undee65327273un__dee
under64624213un__der
uneager839753uneager
unease63816643unease_
uneases73316263uneases
unended92811823unended
unevaded1336423unevaded
uneven957913un_even
unfading1347693unfading
unfaked153211173unfaked
unfallen1144463unfallen
unfasten1144843unfasten
unfazed20299053unfazed
unflawed1536123unflawed
ungated92717213ungated
unglazed1936263unglazed
ungraded11209923ungraded
unhanded132910183unhanded
unlacing1148653unlacing
unlaid7311753unla_id
unlash938793unla_sh
unlashed12289183unlashed
unlashes11238043unlashes
unlatch1245053unlatch
unlay84613703unla__y
unlaying1258363unlaying
unlays93810493unla_ys
unlead73312373unlead__
unleadeds1143943unleadeds
unleading1138673unleading
unleads8228623unlead_s
unlearn735953unlearn
unleased9310713unleased
unled64021073unl__ed
unlet54133333unl__et
unlevel1035913unlevel
unlike102614063unlike_
unliked122411283unliked
unlined82515803unlined
unlive92712333unlive_
unlived112511373unlived
unlives102010953unlives
unload73010803unload__
unloaders1044403unloaders
unloading1137193unloading
unloads8278523unload_s
unlobed10219743unlobed
unloosen8125263unloosen
unloved112310533unloved
unmake122811213unmake_
unmaker13279513unmaker
unmakes132810793unmakes
unman72715423unma__n
unmated103317023unmated
unnamed102410273unnamed
unopen838913un_open
unpadded1345183unpadded
unpaged113311043unpaged
unpaved133410053unpaved
unpen72913573un__pen
unplaced1338613unplaced
unplayed1437263unplayed
unraked122914013unraked
unrated82621553unrated
unravel1038063unravel
unrazed172511453unrazed
unrisen7229283unrisen
unroven10238143unroven
unsafe9310693unsafe_
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsawn9317463unsa_wn
unseen62012623un_seen
unshaded13149263unshaded
unshaken15175403unshaken
unshapen13155443unshapen
unshaven14154883unshaven
unslaked1338463unslaked
untame82513603untame_
untamed102913223untamed
untaxed152710583untaxed
unwaxed18308393unwaxed
unwoven13176673unwoven
uplander1145533uplander
uploaded1234533uploaded
velamen1237123velamen

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.393454684.5
2DLD Change Limit1340272006.14021828.5
3Display Results2002000.0762631.6
 (SQL Overall)1786912006.60927037.5
 
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.