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

174 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
updaters1125518(None) 
updater10347251updater_
updates10329791update_s
daters74827372__daters
paters84935832_p_aters
platers93924092_platers
praters94921652_praters
update93810292update__
updated11369422update_d
upgathers1582532upgathers
uprates93814862uprate_s
upstaters11174802upstaters
abaters95115203_abaters
adapters1136103_adapters
beaters94925043_beaters
bleaters103412323bleaters
bloaters103311023bloaters
boaters93419243_boaters
cadasters1236833cadasters
cadavers1435893cadavers
caters85336503__caters
cheaters133613513cheaters
coaters93525793_coaters
craters95021893_craters
cutwaters1443613cutwaters
darers75921873__darers
darters84017603__darters
dater65332313__dater_
dates65639153__date_s
debaters113511923debaters
deters74724683__deters
dewaters122910723dewaters
dilaters92513063dilaters
doters74423913__doters
eaters65535953__eaters
elaters74420193_elaters
floaters112711513floaters
fraters103517213_fraters
gaters74728643__gaters
gloaters9288863gloaters
graters85419743_graters
haters94930403__haters
heaters104225223_heaters
inditers93311053inditers
iodates8312903iodate_s
kraters114212343_kraters
locaters102710073locaters
maters85032393__maters
negaters9349783negaters
nidates8311893nidate_s
oaters65029793__oaters
oldsters996733oldsters
opiates9312143opiate_s
outdates93114743outdate_s
pacers105124543_p_acers
padders113312873_padders
pagers94423253_p_agers
palters94021683_palters
papers105125323_p_apers
parers85530743_p_arers
pasters94531733_pasters
patens84820863_p_atens
pater74740723_p_ater_
pates76047893_p_ate_s
patters94825193_patters
patzers184210573_p_atzers
pavers115021823_p_avers
pawers114818783_p_awers
payers114621823_p_ayers
pedalers11239393pedalers
pelters93720313_pelters
pesters93827093_pesters
peters86624593_p_eters
petters93722363_petters
pewters124113353_pewters
piasters102912813_piasters
placers114515263_placers
plaiters103512633_plaiters
planers94517943_planers
planters102915323_planters
plasters103518133_plasters
platens94213983_platens
plater84427693_plater_
plates85432243_plate_s
platters103415283_platters
players124313763_players
pleaters103613793pleaters
porters93722703_porters
posters93928013_posters
potters94024343_potters
pouters94221873_pouters
powters124015663_powters
prater84825353_prater_
prates84633163_prate_s
prayers124212853_prayers
psalters10227713_psalters
puddlers12298683puddlers
punsters103310583punsters
punters93617043_punters
pupates113311433pupate_s
putters94219193_putters
raters63936583__raters
rebaters103413943rebaters
redates83423873redate_s
relaters83218153relaters
repeaters112811993repeaters
seaters74028943_seaters
sedater83713633sedater_
sedates83418043sedate_s
skaters113512963_skaters
slaters73123733_slaters
spacers113813873sp_acers
spaders104214473sp_aders
sparers94519613sp_arers
spates85028173sp_ate_s
spatters103914703spatters
speakers14299453speakers
spearers103711143spearers
specters122811063specters
spelters103912243spelters
spitters104113383spitters
splatters11327543splatters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
sprayers13367053sprayers
spurters103311703spurters
sputters104012873sputters
staters73922343_staters
sweaters113811063sweaters
taters64932203__taters
theaters114211903theaters
treaters83615843treaters
udders83911293u_d_ders
ulsters72711983u_lsters
undated93118463undate_d
undoers82910583und_oers
uniters73814173u_niters
unmakers14256653unmakers
unmiters1037073unmiters
upases84112903up_ase_s
upbearers1343033upbearers
updart9310743upda__rt
updarted1244313updarte_d
updarts1034203upda_rts
updating1236593updating
updives1334713updive_s
updries10209083updrie_s
upgather14152753upgather_
upgazes1933573upgaze_s
upheavers1742593upheavers
uplanders1234853uplanders
uplifters1463283uplifters
uppers102912293up__pers
upraisers11174423upraisers
uprate83916543uprate__
uprated103213323uprate_d
uprisers10206773uprisers
uprivers13215563uprivers
uprooters1164253uprooters
upsetters1143653upsetters
upstagers12173333upstagers
upstairs1043643upstairs
upstares10178583upstares
upstater10156663upstater_
upstates10189643upstate_s
upsteps1133743up_steps
upstirs935293up_stirs
uptakes1336593uptake_s
uptears9106453up__tears
urates65027763u_rate_s
ureters7311823u_reters
utters63817123u__tters
waters95030633__waters

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621747.11020557.2
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.59623524.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.