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

436 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
alerter7211151(None) 
alerted82512221alerted
averter102410551averter
abetter958322abetter
aborter939932aborter
acerber1135242acerber
adepter1036112adepter
aerier64823152a_erier
alert54740652alert__
alertest8310172alertest
alertly1046792alertly
alerts64418222alert_s
alter54828502al__ter
alterer72714002alter_er
amercer1146372amercer
asserter877572asserter
averted112211612averted
averters11249512averters
bleater94515302bleater
blurter9419832blurter
fleeter103210362fleeter
flirter10318672flirter
lefter93613432_lefter
letter63722582_letter
perter84422282_perter
pleater93916332pleater
abater85518123a_bater
abetted1058323abetted
abetters1057173abetters
abettor956193abettor
aborted10310423aborted
aborters1038573aborters
absenter1086773absenter
abutter957513abutter
accepter14144933accepter
acerate92818913acerate_
acerated113113983acerated
acuter84412863a_cuter
adapter1036173adapter
adherer1137573adher_er
adopter1036763adopter
adorer74713453ador_er
adorner8246983adorner
adverted1336103adverted
aerate64830553a_erate_
aerated85322373a_erated
aerates74627493a_erates
aerator7314843a_erator
aerie54634603a_erie_
aeried74221863a_eried
aeries64737783a_eries
aether94213673a_ether
affecter1644523affecter
aflutter1163813aflutter
after85719793a__fter
agented939423agented
aglitter935093aglitter
airer54927893a_ir_er
airier64619363a_irier
airted74214503a_irted
alarmed1037743alarmed
alastor739673alastor
alate55340333al_ate_
alated75625153al_ated
alates64833973al_ates
albite8313313albite_
albites9313203albites
alder65421913al__der
aldermen1145043aldermen
aleatory1148823aleatory
alee46652323ale__e_
alegar739283ale_gar
alerting91312383alerting
alertness946053alertness
aliener71011193aliener
aligner8108313aligner
aliner65621983al_iner
allayer10148213allayer
alleger8319633alleger
allergen9135893allergen
allotter866473allotter
allover1038583allover
allurer7348433allurer
almner85710723al_mner
almoner949383almoner
altar55520643al__tar
altered83215743alter_ed
alterers82512493alter_ers
alters64924223al__ters
ameer75618983ame__er
amender10349613amender
amerce10310513amerce_
amerced1256523amerced
amercers1256133amercers
amerces1149853amerces
ammeter1148393ammeter
angrier839023angrier
anteater8311603anteater
aperies9423203aperies
aperture1046383aperture
apter76120203a__pter
arbiter939933arbiter
arete56031353are_te_
aretes64425353are_tes
armer76924443a__rmer
arrester839253arrester
artel56122743a__rtel
artery9911453a__rtery
artier63419733a__rtier
asperser10408303asperser
assenter867703assenter
asserted957903asserted
asserters956393asserters
assertor865723assertor
assorter866673assorter
aster55434893a__ster
atelier7311623atelier
attester836503attester
avenger1135493avenger
averred11237593averred
averse95811183averse_
avert86029493avert__
averts95715243avert_s
awaiter1057443awaiter
awarder1135893awarder
aweather1434263aweather
axletree1543983axletree
balloter1078893balloter
baluster1037053baluster
barter85525373_barter
beater84729393_beater
beerier93613023beerier
belter84720963_belter
better84723703_better
blaster94017303blaster
blatter94415653blatter
bleaker133510533bleaker
blearier1037333blearier
bleated104015973bleated
bleaters103412323bleaters
bleeder10359643bleeder
bleeper11458253bleeper
blender104613843blender
blesser9329293blesser
blether12459913blether
blister94415313blister
bloater94013423bloater
blotter94612853blotter
blunter94512033blunter
blurted10399783blurted
blurters10348373blurters
bluster94215313bluster
calender1138273calender
calypter1544063calypter
caperer113013403caper_er
carter84932273_carter
caterer92815943cater_er
cavorter1335783cavorter
center84421413_center
certes84623083_certes
charter123918303charter
cheater124816963cheater
chertier1387873chertier
clatter94014973clatter
cleaner93712303cleaner
clearer93710823clearer
cleated103417843cleated
cleaver124110803cleaver
clefted13326753clefted
clerked14326653clerked
clever114611533cle_ver
clouter93511693clouter
cluster94013333cluster
clutter94211663clutter
clyster12317453clyster
coercer1138383coercer
courter94516483courter
curter85320083_curter
darter75320363_darter
defter104215923_defter
deserter91211603deserter
deter65028043_de_ter
dexter143810893_dexter
diester83013683diester
dieter73516773die_ter
diverter12238623diverter
eagerer8248823eager_er
eater54639843__eater
eerier64320023_eerier
elater64724203el_ater
elected102812613elected
electee92513243electee
elector93313263elector
enter54726383__enter
erecter93113393erecter
ester54727713__ester
everted112711853everted
evertor1038723evertor
exerted152210053exerted
falter94519053fal__ter
falterer11239863falter_er
feater95224053_feater
fester94723513_fester
fetter94120383_fetter
fiercer12356953fiercer
fierier103511193fierier
flatter103815963flatter
fleecer12368033fleecer
fleer86020773fle__er
fleeted113310233fleeted
flenser1036783flenser
flesher133610923flesher
flirted11428673flirted
flirters11337933flirters
flirtier1144893flirtier
flitter103413903flitter
floater104413353floater
flouter104311343flouter
fluster103913063fluster
fluter95316863fl_uter
flutter104012093flutter
fretter103412753fretter
galeate83916793galeate_
galeated104111583galeated
galere73716683galer_e_
galeres83514343galer_es
galette84212703galette_
galettes93111163galettes
gamester1137323gamester
garter74420513_garter
gauleiter1042933gauleiter
getter74117613_getter
glarier84112213glarier
gleamer10328513gleamer
gleaner8379773gleaner
gleeted9379323gleeted
gleetier934913gleetier
glister84013343glister
glitter84211803glitter
gloater83711013gloater
greater84416493greater
greeter82812673greeter
halter94420883hal__ter
heater94828303_heater
hefter124313923_hefter
herder104516463_herder
hurter93915853_hurter
inserter82312133inserter
inverter112411073inverter
jeerer13389933jeer_er
jerker17369043_jerker
jester134319153_jester
keester11319913keester
kelter103214383_kelter
kiester11329973kiester
klezmer2231933klezmer
klister113410643klister
lamenter1038863lamenter
lamster9109913lamster
larder73720973_larder
larger74417513_larger
larker104519243_larker
laster64830633_laster
later54843923_l_ater
latter65027893_latter
leader74824653_leader
leaker104620073_leaker
leaner64022193_leaner
leaper88118943_leaper
learier73415663_learier
learner7319383_learner
leaser65322673_leaser
leather103815783_leather
leaver94321513_leaver
lecher113415853_lecher
lectern937033_lectern
lector83514993_lector
ledger85914393_ledger
leer46239353_le__er
leerier73111503leerier
leger65721513_le_ger
leister73212753_leister
lender73921273_lender
lenten6312883_lenten
leper74820743_le_per
lesser63514853_lesser
letted74118543_letted
letters73819853_letters
lever85125163_le_ver
levier94013873_levier
lewder10479613_lewder
lifter93814813_lifter
linter64625343_linter
lister64527253_lister
liter54736343_l_iter
litter64324853_litter
lofter94614723_lofter
loiter64619173_loiter
looter64222323_looter
lotter64025603_lotter
lurer54625313_lur_er
lurker103613293_lurker
luster64023673_luster
macerater13259523macerater
maleate94117543maleate_
maleates103316343maleates
maltster1035303maltster
meeter83616503_meeter
melter83520113_melter
mercer105214203_mercer
merer75126233_mer_er
merger95016483_merger
meter75130323_me_ter
molester1099373molester
neater64424313_neater
nester64124183_nester
netter63722023_netter
neuter63713793_neuter
oldster896573oldster
oleaster837263oleaster
oleate6318883oleate_
oleates7417833oleates
onerier7311613onerier
paleate94120003paleate_
palette93613983palette_
palettes103112833palettes
palter84423263pal__ter
palterer102411283palter_er
paltrier1037533paltrier
paperer113111903paper_er
pearter9412743pearter
pelter83321623_pelter
pester84827593_pester
peter74427593_pe_ter
petter83924773_petter
pewter114013673_pewter
piercer11337773piercer
plaiter93615393plaiter
planter94017803planter
plaster93318693plaster
plater84427693pl_ater
platter93917413platter
pleader103511753pleader
pleaser93912343pleaser
pleated103816633pleated
pleaters103613793pleaters
pleather1356653pleather
pledger11359173pledger
plotter94113663plotter
porter84224413_porter
prester93519623prester
quarter163211853quarter
querier16310013querier
quester161410023quester
reenter73217793reenter
relater73723143relater
reletter81311023reletter
renter64527413_renter
rester63832433_rester
reverter114812873reverter
salter64325083sal__ter
saluter73512453sal_uter
scepter1138363scepter
seater64534163_seater
serer55935513_ser_er
serger73819743_serger
server94917713_server
setter64023723_setter
sheeter103814913sheeter
shelter103214963shelter
shorter103515503shorter
silenter838873silenter
skeeter113410413skeeter
skelter113610003skelter
skirter11338483skirter
slater64429183sl_ater
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
sleeted83113223sleeted
sleetier837883sleetier
slender83413593slender
slitter73615873slitter
slotter73314453slotter
smarter94113133smarter
smelter93311913smelter
snorter74412663snorter
sorter64425093_sorter
specter113111733specter
spelter94113703spelter
sporter93616553sporter
spurter94013003spurter
starter73817883starter
sterner7411913sterner
stertor7310093stertor
svelter10359673svelter
sweater103712723sweater
sweeter103212003sweeter
swelter103711173swelter
swerver1365733swerver
talented938423talented
taperer92511793taper_er
tarter64023563_tarter
taverner1134423taverner
teeter65420313_teeter
tenter64623933_tenter
termer85717253_termer
terser67317823_terser
tester64227153_tester
tetter64322453_tetter
theater104014253theater
treater74219833treater
tweeter10288533tweeter
ulster63712103ul_ster
unalerted1047963unalerted
ureter6313203ure_ter
valerate11311473valerate_
valerates12310543valerates
valeted1139013vale_ted
venter94218723_venter
verger104315703_verger
verier94620963_verier
verser94516963_verser
vertex1637373_vertex
vetter93417643_vetter
wagerer11328493wager_er
waterer103314073water_er
waterier11312083waterier
waverer13319523waver_er
welter93417383_welter
wester94222893_wester
wetter93919443_wetter
whetter13348803whetter
wrester102812413wrester
yester93417983_yester
zester153617793_zester

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.390458182.1
2DLD Change Limit1340274366.95319276.1
3Display Results4364360.1562794.9
 (SQL Overall)1786914367.49923828.6
 
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.