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

260 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
uptakes133659(None) 
uptake1236961uptake_
betakes134212522betakes
cupcakes1843712cupcakes
intakes11310942intakes
outtakes12310032outtakes
retakes113718862retakes
reuptakes1543212reuptakes
splakes1349672splakes
stakes103927292_stakes
takes94437792__takes
uncakes133012742uncakes
unmakes132810792unmakes
untaken1137642untaken
upases84112902up_ases
updates10329792updates
upgazes1933572upgazes
uprates93814862uprates
upstages11147372upstages
upstares10178582upstares
upstates10189642upstates
uptalked1533052uptalked
uptalks1333722uptalks
uptimes1177552uptimes
awakes135012473_awakes
bakes117035373__bakes
berakes134815773berakes
betake124512703betake_
betaken13438283betaken
brakes124923123_brakes
bupkes144811483bup__kes
butanes9312743butanes
cakes116037673__cakes
cetanes9315133cetanes
comakes154413643comakes
crakes124921813_crakes
cupcake1743953cupcake_
cuttages11297223cuttages
dotages92311793dotages
drakes114715863_drakes
ectases92911673ectases
entases72816273entases
epitases1038933epitases
estates74520183estates
etapes85415293_etapes
fakes126032483__fakes
flakes134118873_flakes
hakes126034303__hakes
heptanes1339003heptanes
hotcakes1744703hotcakes
intake10510863intake_
jakes165023643__jakes
lakes95737653__lakes
latkes104715873lat_kes
makes115336853__makes
metages102714973metages
metates92720013metates
mistakes141213413mistakes
mutases92012043mutases
mutates92215793mutates
notates72817483notates
nutates73214973nutates
oatcakes1445543oatcakes
octanes91111393octanes
octaves12316963octaves
opiates9312143opiates
optimes1148473optimes
outages82317323outages
outbakes1439993outbakes
outpaces122411943outpaces
outtake11310793outtake_
paces96741113_p_aces
pages85235073_p_ages
pales75753803_p_ales
panes76148693_p_anes
pares77164483_p_ares
partakes1449923partakes
pases75346503_p_ases
pates76047893_p_ates
paves104833923_p_aves
paxes144928423_p_axes
peaces106324083_peaces
peages94321853_peages
peaked136117403_peaked
peaks114825623_peak_s
peases85229473_peases
pekes114623563_p_ekes
phages125213513_phages
phases114618403_phases
pikakes1245823pikakes
pikes115031033_p_ikes
places104323703_places
plages94520153_plages
planes85028083_planes
plates85432243_plates
pokes116133013_p_okes
potages102416423potages
prases84429023_prases
prates84633163_prates
praxes156215183_praxes
ptoses83514673_ptoses
pukes114523023_p_ukes
pupates113311433pupates
putamen1135923putamen
puttees93612913puttees
putties94420023putties
putzes174212523put_zes
quakes194013343_quakes
rakes94440353__rakes
remakes134116173remakes
retake104718533retake_
retaken113911803retaken
retaker113714313retaker
retakers123511133retakers
retapes93917423retapes
retaxes143615093retaxes
reuptake1443463reuptake_
rewakes144614983rewakes
rotates72819773rotates
ruptures1056683ruptures
sakes95540753__sakes
septages1168263septages
shakes135024593_shakes
shitakes1546113shitakes
slakes104021883_slakes
snakes103919603_snakes
spaces104722633sp_aces
spades94222583sp_ades
spaes76029973sp_a_es
spake114322743sp_ake_
spales84728103sp_ales
spares84834553sp_ares
spates85028173sp_ates
spathes125116533spathes
speaker133311213speaker
speakers14299453speakers
speaks125114583speak_s
spikes124520713sp_ikes
splake1259783splake_
spokes124417213sp_okes
stades74626243_stades
stages75629493_stages
stake95927533_stake_
staked114621943_staked
stales65538293_stales
stanes64933403_stanes
stapes85028733_stapes
stares66038753_stares
stases64225563_stases
states64337083_states
staves94525193_staves
stokes104821793_stokes
strakes114218073strakes
surtaxes1536513surtaxes
tabes76033923__tabes
taces76237803__taces
tajes124920693__tajes
takas95520683__takas
take84739263__take_
taken94819143__taken
taker95229003__taker
takers103923743__takers
tales55451373__tales
tames75242013__tames
tapes75838603__tapes
tares57456563__tares
tates55444983__tates
taxes124730823__taxes
tikes95628903__tikes
tokes95234973__tokes
tykes125817063__tykes
ukases10358063u_kases
ukes86122813u___kes
ullages838953ullages
umiaks1244953umiak_s
unbaked143312893unbaked
unbales92914863unbales
unbrakes14258413unbrakes
uncages103213773uncages
uncake122813523uncake_
uncaked143514353uncaked
uncases93516553uncases
uneases73316263uneases
unfaked153211173unfaked
unitages938273unitages
unlaces92513623unlaces
unlades82612833unlades
unmake122811213unmake_
unmaker13279513unmaker
unmakers14256653unmakers
unraked122914013unraked
unstates81314993unstates
untacked15239923untacked
untacks1357503untacks
untame82513603untame_
untamed102913223untamed
untaxed152710583untaxed
unties64326923unt_ies
untunes72211253untunes
unyokes1466733unyokes
upas68322383up_a__s
upcasts11185643upcasts
updarts1034203updarts
update93810293update_
updated11369423updated
updater10347253updater
updaters11255183updaters
updives1334713updives
updries10209083updries
upgaze1833543upgaze_
upgazed2033423upgazed
upgrades12216063upgrades
upheaves1643913upheaves
uphroes1236303uphroes
uplands1036943uplands
upmarket1644663upmarket
uppiles11208263uppiles
upraise9158603upraise
upraises10188473upraises
uprate83916543uprate_
uprated103213323uprated
uprises92012733uprises
upscales12155993upscales
upsides10319633upsides
upsizes18297163upsizes
upstage10167443upstage_
upstaged12135243upstaged
upstager11164633upstager
upstagers12173333upstagers
upstairs1043643upstairs
upstands1144093upstands
upstare9158683upstare_
upstared11156573upstared
upstarts10165273upstarts
upstate91610493upstate_
upstater10156663upstater
upstaters11174803upstaters
upstrokes1543153upstrokes
uptalk1234653upta_lk
uptears9106453uptears
upthrew1542663upthrew
upticks1535153upticks
uptilts934733uptilts
uptime1067673uptime_
uptore8279453uptore_
uptoss836093upt_oss
uptosses1043973uptosses
uptowns12194343uptowns
upturns9264973upturns
upwafts1541943upwafts
upwards13135963upwards
urares64519093u_rares
urases63723563u_rases
urates65027763u_rates
ureases74416723ureases
usages759603u_sages
utas45924953u_ta__s
utes45930883u_t__es
wakes126633653__wakes
watapes12228383watapes

Search took 9 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.390458182.1
2DLD Change Limit1340272608.26616214.3
3Display Results2602600.1262063.5
 (SQL Overall)1786912608.78220347.4
 
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.