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

231 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
updater1034725(None) 
update93810291update_
updated11369421updated
updaters11255181updaters
updates10329791updates
dater65332312__dater
pater74740722_p_ater
plater84427692_plater
prater84825352_prater
sedater83713632sedater
undated93118462undated
updarted1244312updarted
upgather14152752upgather
uprate83916542uprate_
uprated103213322uprated
uprates93814862uprates
upstater10156662upstater
abater85518123_abater
adapter1036173_adapter
apter76120203ap__ter
beater84729393_beater
bleater94515303bleater
bloater94013423bloater
boater84622093_boater
cadaster1136903cadaster
cadaver1335793cadaver
cater74840723__cater
cheater124816963cheater
coater84329573_coater
crater85026643_crater
cutwater1344833cutwater
dafter104813343__dafter
darer65230793__darer
darter75320363__darter
date56443323__date_
dated75530993__dated
daters74827373__daters
dates65639153__dates
debater104114693debater
deter65028043__deter
dewater112912423dewater
dilater83515653dilater
doter65428623__doter
eater54639843__eater
elater64724203_elater
feater95224053_feater
floater104413353floater
frater94520593_frater
gater64533653__gater
gloater83711013gloater
grater74625443_grater
greater84416493greater
hater85034753__hater
heater94828303_heater
inditer83514233inditer
iodate7313503iodate_
iodated9310023iodated
iodates8312903iodates
irater65218353_irater
krater104014313_krater
later54843923__later
locater93113603locater
mater74438863__mater
neater64424313_neater
negater83711963negater
nidate7313783nidate_
nidated939863nidated
nidates8311893nidates
oater55433733__oater
oldster896573oldster
opiate8513463opiate_
opiated1039483opiated
opiates9312143opiates
outdate83016423outdate_
outdated1012513193outdated
outdates93114743outdates
pacer96131613_p_acer
padder103415493_padder
pager84728203_p_ager
paler75436933_p_aler
palter84423263_palter
paper95128663_p_aper
parer75839903_p_arer
paster85734373_paster
pate65350463_p_ate_
pated85237843_p_ated
paten74827343_p_aten
paters84935833_p_aters
pates76047893_p_ates
patter84628263_patter
patzer173111643_p_atzer
paver104225833_p_aver
pawer104422973_p_awer
payer105125723_p_ayer
pearter9412743_pearter
peatier94017233_peatier
pedaler103410693pedaler
pedate93117763pedate_
pelter83321623_pelter
perter84422283_perter
pester84827593_pester
peter74427593_p_eter
petter83924773_petter
pewter114013673_pewter
phatter123810203_phatter
piaster93012883_piaster
placer105117743_placer
plaiter93615393_plaiter
planer84122653_planer
planter94017803_planter
plaster93318693_plaster
plate74635113_plate_
plated95225773_plated
platen84518203_platen
platers93924093_platers
plates85432243_plates
platier93716293_platier
platter93917413_platter
player115215213_player
pleater93916333pleater
porter84224413_porter
poster84129173_poster
potter83926983_potter
pouter83923983_pouter
powter114116033_powter
prate75135983_prate_
prated94924923_prated
praters94921653_praters
prates84633163_prates
prayer114815293_prayer
psalter9247813_psalter
puddler112910753puddler
pudgier11377723pudgier
punster92911103punster
punter84320023_punter
pupate104213123pupate_
pupated12319353pupated
pupates113311433pupates
putter83921443_putter
rater54943283__rater
rebater93517913rebater
redate74124683redate_
redated93120923redated
redates83423873redates
relater73723143relater
repeater102615443repeater
seater64534163_seater
sedate73019813sedate_
sedated93714353sedated
sedates83418043sedates
skater105015493_skater
slater64429183_slater
spacer104917793sp_acer
spader94317133sp_ader
sparer84524963sp_arer
spate74731583sp_ate_
spates85028173sp_ates
spatter94016523spatter
speaker133311213speaker
spearer93913663spearer
specter113111733specter
spelter94113703spelter
spitter94015183spitter
splatter10348883splatter
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
sprayer12369043sprayer
spurter94013003spurter
sputter94014053sputter
stater64427563_stater
sweater103712723sweater
tater54138613__tater
theater104014253theater
treater74219833treater
udder76314283u_d_der
ulster63712103u_lster
unbated103317733unbated
under64624213und__er
undoer73113043und_oer
uneager839753uneager
uneaten7412543uneaten
ungated92717213ungated
uniter64619143u_niter
unmaker13279513unmaker
unmated103317023unmated
unmiter9310393unmiter
unrated82621553unrated
unsated83419933unsated
upases84112903up_ases
upbearer1243583upbearer
updart9310743upda_rt
updarts1034203updarts
updating1236593updating
updive1234903updive_
updived1434093updived
updives1334713updives
updove1234483updove_
updried11226473updried
updries10209083updries
upgathers1582533upgathers
upgaze1833543upgaze_
upgazed2033423upgazed
upgazes1933573upgazes
upheaver1643443upheaver
uplander1145533uplander
uplifter1363903uplifter
upper93714263up__per
upraiser10175843upraiser
upriser9218763upriser
upriver12196933upriver
uprooter1085243uprooter
upsetter1034643upsetter
upstager11164633upstager
upstair943983upstair
upstare9158683upstare
upstate91610493upstate_
upstaters11174803upstaters
upstates10189643upstates
upstep1035503up_step
upstir835383up_stir
uptake1236963uptake_
uptakes1336593uptakes
uptear896783up__tear
upwafted1742193upwafted
urate55432163u_rate_
urates65027763u_rates
urbaner9177133urbaner
ureter6313203u_reter
utter54218763u__tter
water84733313__water

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.406440125.6
2DLD Change Limit1340272316.65620136.3
3Display Results2312310.0763039.5
 (SQL Overall)1786912317.13825033.8
 
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.