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

315 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
updates1032979(None) 
update93810291update_
updated11369421updated
updater10347251updater
updaters11255181updaters
uprates93814861uprates
dates65639152__dates
iodates8312902iodates
nidates8311892nidates
opiates9312142opiates
outdates93114742outdates
pates76047892_p_ates
plates85432242_plates
prates84633162_prates
pupates113311432pupates
redates83423872redates
sedates83418042sedates
spates85028172sp_ates
undated93118462undated
upases84112902up_ases
updarted1244312updarted
updarts1034202updarts
updives1334712updives
updries10209082updries
upgazes1933572upgazes
uprate83916542uprate_
uprated103213322uprated
upstates10189642upstates
uptakes1336592uptakes
urates65027762u_rates
abates85825033_abates
ablates92416903ablates
adages8412953_adages
addaxes1634573addaxes
aerates74627493aerates
agates76121343_agates
agnates82813193agnates
airdates939723airdates
alates64833963_alates
andantes9310853andantes
annates72415423annates
aplites9314933aplites
ates45047923___ates
aviates10313063aviates
bates75846343__bates
bedmates1349183bedmates
berates94126873berates
borates94823013borates
carates95630613carates
cates75951893__cates
caudates11310263caudates
cerates95428253cerates
comates114123643comates
crates85736063_crates
creates95225203creates
cupcakes1843713cupcakes
cuprites1259023cuprites
curates95323833curates
daces85030683__daces
dales66439743__dales
dames85435853__dames
dares66146703__dares
date56443323__date_
dated75530993__dated
dater65332313__dater
daters74827373__daters
datos65222783__datos
dazes155024143__dazes
debates103718533debates
delates83526283delates
derates84028893derates
dilates83220663dilates
dites66339153__dites
donates83217223donates
dotes65836693__dotes
elates65032363_elates
eluates72014683eluates
enates64026433_enates
endites83717063endites
epidotes1147023epidotes
epilates10313503epilates
equates162012323equates
ergates8314493ergates
estates74520183estates
expiates17810213expiates
exudates1636623exudates
fates85139233__fates
fixates1737393fixates
folates103218453folates
furcates1339883furcates
gates65939513__gates
gelates83219583gelates
gradates10510783gradates
grates75429893_grates
gyrates113610263gyrates
hamates122917683hamates
hates86742573__hates
humates122813193humates
hydrates15229413hydrates
ideates8313733ideates
indites83618983indites
ingates82716913ingates
inmates92715783inmates
inundates1045773inundates
iodate7313503iodate_
iodated9310023iodated
judases1534443judases
karates115617473karates
lapidates1247143lapidates
legates82917683legates
ligates82318383ligates
locates93218813locates
lurdanes936063lurdanes
luxates1436973luxates
lysates10317473lysates
madames12310063madames
malates93522603malates
mandates11314093mandates
mates75251363__mates
mediates112814063mediates
metates92720013metates
misdates111113633misdates
muriates10312083muriates
mutates92215793mutates
nates55238333__nates
negates83215843negates
nidate7313783nidate_
nidated939863nidated
notates72817483notates
nutates73214973nutates
oblates91913243oblates
oleates7417833oleates
operates10515413operates
ophites12310103ophites
opiate8513463opiate_
opiated1039483opiated
orates64328613_orates
outdares92712463outdares
outdate83016423outdate_
outdated1012513193outdated
outrates82421373outrates
oxidates1636333oxidates
paces96741113_p_aces
padles95221123_padles
padres95016983_padres
pages85235073_p_ages
palates93624933palates
pales75753803_p_ales
panes76148693_p_anes
pares77164483_p_ares
pases75346503_p_ases
pastes85233913_pastes
pate65350463_p_ate_
pated85237843_p_ated
paten74827343_p_aten
patens84820863_p_atens
pater74740723_p_ater
paters84935833_p_aters
paths105521383_p_aths
pats66460853_p_at_s
paves104833923_p_aves
paxes144928423_p_axes
peaces106324083_peaces
peages94321853_peages
peases85229473_peases
peats76140193_peat_s
pedate93117763pedate_
penates93321603penates
phages125213513_phages
phases114618403_phases
pirates93020333pirates
pistes85325633_pistes
places104323703_places
plages94520153_plages
planes85028083_planes
plate74635113_plate_
plated95225773_plated
platen84518203_platen
platens94213983_platens
plater84427693_plater
platers93924093_platers
platies93722543_platies
plats75531373_plat_s
platys11459853_platys
podites103014733podites
pontes83627853_pontes
prases84429023_prases
prate75135983_prate_
prated94924923_prated
prater84825353_prater
praters94921653_praters
prats76333393_prat_s
praxes156215183_praxes
predates11615813predates
puddles113613823puddles
pulsates1048813pulsates
pupate104213123pupate_
pupated12319353pupated
quadrates19117803quadrates
radiates92415293radiates
rates55352013__rates
rebates95123183rebates
redate74124683redate_
redated93120923redated
relates73731433relates
remates93827113remates
replates102919273replates
rotates72819773rotates
ruinates8311883ruinates
sates54949323__sates
savates10312953savates
sedate73019813sedate_
sedated93714353sedated
sedater83713633sedater
sedatest9249393sedatest
senates73322613senates
skates104219403_skates
slates64934063_slates
solates73523853solates
spaces104722633sp_aces
spades94222583sp_ades
spaes76029973sp_a_es
spales84728103sp_ales
spares84834553sp_ares
spate74731583sp_ate_
spathes125116533sp_athes
spats75031383sp_at_s
spites84127333sp_ites
splakes1349673splakes
splats84817303splat_s
sprats85819933sprat_s
sprites94220333sprites
states64337083_states
sublates10315003sublates
sulfates11310793sulfates
sulphates1466163sulphates
summates122610493summates
sundaes8313093sunda_es
supinates1139553supinates
tates55444983__tates
ukases10358063u_kases
ullages838953ullages
ululates848433ululates
unbales92914863unbales
unbated103317733unbated
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
uncrates10314563uncrates
undies73821963und_ies
undines8716083undines
undoes73917403und_oes
undrapes1138603undrapes
undulates1048923undulates
uneases73316263uneases
uneaten7412543uneaten
ungated92717213ungated
unhats91110623unhat_s
unites65024853u_nites
unlaces92513623unlaces
unlades82612833unlades
unmakes132810793unmakes
unmated103317023unmated
unrated82621553unrated
unsated83419933unsated
unstates81314993unstates
upas68322383up_a__s
upbeats1195733upbeat_s
upcasts11185643upcasts
updart9310743upda_rt
updating1236593updating
updive1234903updive_
updived1434093updived
updos8389513upd__os
updove1234483updove_
updrafts1443203updrafts
updried11226473updried
upgather14152753upgather
upgathers1582533upgathers
upgaze1833543upgaze_
upgazed2033423upgazed
upgrades12216063upgrades
upheaves1643913upheaves
uphroes1236303uphroes
uplands1036943uplands
uppiles11208263uppiles
upraise9158603upraise
upraises10188473upraises
uprises92012733uprises
upscales12155993upscales
upsets8409683upset_s
upsides10319633upsides
upsizes18297163upsizes
upstages11147373upstages
upstares10178583upstares
upstate91610493upstate_
upstater10156663upstater
upstaters11174803upstaters
upstep1035503up_step
upsteps1133743up_steps
uptake1236963uptake_
uptalks1333723uptalks
uptimes1177553uptimes
upwafted1742193upwafted
upwafts1541943upwafts
upwards13135963upwards
urares64519093u_rares
urases63723563u_rases
urate55432163u_rate_
ureases74416723ureases
urinates8314133urinates
usages759603u_sages
utes45930883u___tes
vacates12312833vacates
vulgates12237233vulgates

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.403443402.0
2DLD Change Limit1340273155.67323625.4
3Display Results3153150.1102863.6
 (SQL Overall)1786913156.18628886.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.