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

339 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
alterer7271399(None) 
altered83215731altered
alterers82512491alterers
falterer11239851falterer
palterer102411271palterer
adherer1137572adherer
adulterer1043552adulterer
alerter72111512al_erter
aliener71011192aliener
alleger8319632alleger
allurer7348432allurer
alter54828502alt__er
alters64924222alter_s
austerer838382austerer
banterer102811772banterer
barterer102711632barterer
batterer102713212batterer
caterer92815942caterer
enterer72015632enterer
faltered122810982faltered
falterers12238032falterers
filterer11258142filterer
haltere103614702haltere_
haltered123112552haltered
halteres113414592halteres
latherer111310442latherer
miterer92511332miterer
paltered113012482paltered
palterers11249532palterers
patterer103112172patterer
utterer71910462utterer
waterer103314072waterer
abetter958323abetter
abjurer1634753abjurer
acceder1235363acceder
acerber1135243a_cerber
adhere10310333adhere_
adhered1239233adhered
adherers1296923adherers
adheres11310163adheres
adjurer1534823adjurer
admirer1035523admirer
adorer74713453a_dorer
adulterers1143173adulterers
aerier64823153a__erier
aether94213673aet_her
after85719793aft__er
afters94717073after_s
airer54927893a__irer
alder65421913al__der
aldermen1145043aldermen
alders74218423alder_s
alee46652323al_e_e_
alegar739283al_egar
alert54740653al_er_t
alerted82512223al_erted
alerts64418223al_erts
aliened81011743aliened
alienee71013153alienee
alieners889823alieners
alienor7116303alienor
aligner8108313aligner
aliner65621983al_iner
alkene104114003alkene_
alkenes114212753alkenes
allayer10148213allayer
allee54932123alle_e_
allees64521483alle_es
allege74314653allege_
alleged9389323alleged
allegers9378233allegers
alleges84212573alleges
allele64514563allele_
alleles73812033alleles
allergen9135893allergen
allergy1144503allergy
allover1038583allover
allure63012943allure_
allured8299173allured
allurers8286773allurers
allures72913113allures
almemar1144303almemar
almner85710723al_mner
almoner949383almoner
altar55520643alt__ar
altars64518153altar_s
alterant8614963alterant
altering91917113altering
alterity1149843alterity
althaea1044353althaea
althea938203alt_hea
altimeter1146613altimeter
ambeer104511603ambe_er
ameer75618983a_me_er
amercer1146373a_mercer
ammeter1148393ammeter
ampere10514413ampere_
amperes11313983amperes
angered93013473angered
answerer1144273answerer
anteater8311603anteater
anteed75616113ante_ed
anterior8611053anterior
antevert1148993antevert
anther93715063ant_her
antired82316193antired
antler64615553ant_ler
antlered938263antlered
antre55224523ant_re_
antres65021003ant_res
antsier7410773antsier
apter76120203apt__er
apteral9311523apteral
apteria9312913apteria
apteryx1942383apteryx
armorer9259913armorer
arteries8321483arteries
artery9911453arter_y
artier63419733art_ier
artsier768943artsier
asperser10408303asperser
aspirer967903aspirer
asserter877573asserter
assurer767793assurer
aster55434893ast__er
asteria7316183asteria
astern64815813aster_n
asters65631603aster_s
atelier7311623a_telier
atoner64817193a_toner
attemper12103633attemper
attender935913attender
attester836503attester
attire62412383attire_
attired8238913attired
attires72312953attires
augurer8136343augurer
austere7312993austere_
auteur6107943aute_ur
averter102410553a_verter
axletree1543983axletree
bantered113313633bantered
banterers112410003banterers
bartered113113013bartered
barterers11269633barterers
battener10369393battener
battered113315053battered
batterers113110713batterers
bitterer10309773bitterer
blatherer14176713blatherer
bleeder10359643bleeder
bleeper11458253bleeper
blether12459913blether
blusterer11176293blusterer
bolsterer1145483bolsterer
cantered113415983cantered
caperer113013403caperer
capturer1246093capturer
careerer1038583careerer
catered103117773catered
caterers102814403caterers
charterer14197323charterer
chatterer14196843chatterer
cheerer123511753cheerer
clatterer11186983clatterer
clearer93710823clearer
clever114611533cl_ever
cleverer1334563cleverer
coherer122912783coherer
coverer123113523coverer
dapperer1335763dapperer
deterger10147593deterger
deterrer9137013deterrer
ditherer12187763ditherer
eagerer8248823eagerer
easterner945053easterner
entered82718883entered
enterers82214153enterers
falter94519053falt__er
falters103916473falter_s
fastener11227833fastener
fattener11268113fattener
fetterer11207813fetterer
filtered12259043filtered
filterers12206973filterers
flatterer12187673flatterer
fleecer12368033fleecer
fleer86020773fl_e_er
fleered11309503fleered
fleeter103210363fleeter
floorer10248073floorer
flowerer1435453flowerer
flutterer12185263flutterer
fosterer11239523fosterer
galere73716673gal_ere_
galeres83514333gal_eres
gartered10319583gartered
gatherer12147903gatherer
halter94420883halt__er
halters104619803halter_s
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259133hastener
hoverer13319823hoverer
integer837993integer
jabberer1944023jabberer
jeerer13389933_jeerer
labeler92310183labeler
laborer9249503laborer
lagered92311153lagered
lateen64014863late_en
lateener835763lateener
latened8711923latened
later54843923lat__er
laterad8310843laterad
lateral7313573lateral
latexes1438313latexes
lather95124353lat_her
lathered121512323lathered
latherers12158853latherers
lathier10310833lathier
latter65027893lat_ter
laveer94110423lave_er
layered11259413layered
leer46239353_l_e_er
leered73816223_leered
leerier73111503_leerier
leger65721513_l_eger
leper74820743_l_eper
letter63722583_letter
letterer8259223letterer
lever85125163_l_ever
lieder74912323_lieder
liefer9529573_liefer
liever94611863_liever
litterer82810173litterer
loiterer837083loiterer
lurer54625313_l_urer
maltier93015483malt_ier
maltster1035303maltster
mastered112614003mastered
mattered112412903mattered
maturer938983maturer
merer75126233__merer
metered103514013metered
mitered103213233mitered
miterers10219683miterers
mutterer10218913mutterer
nattered92011623nattered
offerer1335543offerer
oftener1035923oftener
orderer8127943orderer
oysterer1136103oysterer
palaverer1443163palaverer
palter84423263palt__er
palters94021683palter_s
paltrier1037523paltrier
pamperer14228333pamperer
panderer112210913panderer
paperer113111903paperer
parterre1036983parterre
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
peltered112510453peltered
pesterer102412713pesterer
petered103314973petered
pewterer13256313pewterer
pilferer1344923pilferer
plasterer1178103plasterer
potterer102310263potterer
poulterer1145423poulterer
putterer10209913putterer
quarterer18145713quarterer
queerer16106503queerer
raftered1237663raftered
rattener8238533rattener
realtered1037893realtered
retirer74715013retirer
reverer103815833reverer
salter64325083salt__er
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltier74318633salt_ier
saltire73113033saltire_
saltires83112423saltires
saltpeter1153163saltpeter
saunterer945033saunterer
scatterer11186293scatterer
serer55935513__serer
severer103511563severer
shatterer12177203shatterer
sheerer103813843sheerer
shelterer1245033shelterer
silverer11216733silverer
slaverer11196993slaverer
sleeker11339823sleeker
sleeper93211563sleeper
sliverer11237633sliverer
smatterer11185813smatterer
sneerer73512313sneerer
soberer93110353soberer
solderer947183solderer
starer64027363_starer
steer55423863_ste_er
steerer73113633steerer
stere55328543_stere_
stereo65317913_stereo
steres63929533_steres
sterner7411913_sterner
storer64721673_storer
tamperer12248893tamperer
taperer92511793taperer
tattered92011443tattered
tearer64822903__tearer
termer85717253__termer
terser67317823__terser
titterer8268523titterer
totterer8217793totterer
ulcered1037973ulcered
ulterior845443ulterior
unaltered1037723unaltered
uttered82712433uttered
utterers8218653utterers
wagerer11328493wagerer
waitered1238753waitered
waltzer1934383walt_zer
wanderer122210123wanderer
watered113014953watered
waterers112312783waterers
waterier11312083waterier
waverer13319523waverer
weltered12238433weltered
winterer112110443winterer
witherer14187953witherer
yammerer15225483yammerer
yattered12239533yattered

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.423422437.4
2DLD Change Limit1340273396.62320236.6
3Display Results3393390.1432370.6
 (SQL Overall)1786913397.18924856.2
 
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.