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

347 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
amender1034961(None) 
amended11328311amended
amenders11288351amenders
emender10649841emender
mender93520791_mender
ameer75618982ame__er
amend85717752amend__
amends94713282amend_s
amercer1146372amercer
ascender1136732ascender
asunder856222asunder
attender935912attender
avenger1135492avenger
bender95223302_bender
blender104613842blender
calender1138272calender
damneder1243762damneder
emended11329602emended
emenders11319032emenders
ender64325862__ender
fender103718722_fender
gender83517932_gender
lamenter1038862lamenter
lavender1235142lavender
lender73921272_lender
maunder10328682maunder
meander1049972_meander
melder93915812_melder
mended104418682_mended
menders103818802_menders
minder94822502_minder
render74024142_render
sender73824412_sender
slender83413592slender
spender103713692spender
tender74121842_tender
vender103418422_vender
abetter958323abetter
abider95314463a_bider
abrader1038643abrader
absenter1086773absenter
acceder1235353acceder
acerber1135243acerber
acrider1038623acrider
adder75419593a__dder
adepter1036113adepter
aedes64625143a_e_des
aerier64823153a_erier
aether94213673a_ether
agenda837253agend_a
agendas936933agendas
agendum1144673agendum
agene65621583agen_e_
agenes74720253agen_es
agented939423agented
aginner844663aginner
aider65431133a__ider
akene95818663aken_e_
akenes104817343aken_es
alder65421913a__lder
alerter72111513alerter
alexander1742773alexander
aliener71011193alien_er
aliner65621983alin_er
almner85710723almn_er
almoner949383almon_er
amasser9418733amasser
ambeer104511603am_beer
amber94523213am__ber
ambler104916453am_bler
amebae1049633amebae_
ameers84015573ame__ers
amen66733153amen___
amending12308913amending
amendment1445463amendment
amenity1238333amenity
amens75624843amen__s
ament76036543amen__t
amentia9310153amentia
aments85219803amen_ts
amerce10310513amerce_
amerced1256523amerced
amercers1256133amercers
amerces1149853amerces
amide86128483am_ide_
amides95722663am_ides
amine75835383amin_e_
amines84727983amin_es
ammeter1148393ammeter
ampler104313303am_pler
amuser84712623am_user
anger66225873a__nger
appended1435483appended
arene55329413aren_e_
arenes64928393aren_es
arider74717743a_rider
ascended1246513ascended
ascenders1235683ascenders
assenter867703assenter
atelier7311623atelier
atoner64817193aton_er
attended1035763attended
attendee946403attendee
attenders1045273attenders
augmenter1254123augmenter
aulder7511453a_ulder
avenge1087553avenge_
avenged1245503avenged
avengers1235583avengers
avenges1157543avenges
avenses1049643avenses
avenue957953avenue_
avenues1057183avenues
averter102410553averter
avoider1155813avoider
awarder1135893awarder
bander93928223_bander
bartender1244603bartender
beader94623793_beader
bedder104215783_bedder
bended105521233_bended
bendee94121023_bendee
benders104021063_benders
bendier103111413_bendier
binder94422873_binder
blander103715163blander
bleeder10359643bleeder
blende95413443blende_
blended114710713blended
blenders115210993blenders
blendes104713683blendes
blinder103912983blinder
blonder104011943blonder
blunder103813153blunder
bonder95324783_bonder
bounder104215533bounder
brander103915823brander
breeder103210043breeder
calendar1145013calendar
calenders1237403calenders
cameleer1246033cameleer
ceder85322233_ce_der
cementer1239193cementer
censer84516583_censer
center84421413_center
cheder125113493che_der
cinder94119123_cinder
commender16167923commender
damner95213433dam_n_er
dampener1335533dampen_er
dander811222993_dander
darneder1033983darneder
daunder9348893daunder
deader84220473_deader
defender1337293defender
degender1136893degender
demander12238723demander
denier74420693_denier
denser74115193_denser
denuder9167603_denuder
duende836923duende_
duendes938193duendes
eider64624743__eider
elder64020023__elder
emeer74815363eme__er
emend86214893emend__
emends95711433emend_s
endear74110013__endear
ended74421263__ended
enders74324053__enders
engender1046633engender
enter54726383__enter
evener91010623even_er
expender18136843expender
extender16146333extender
feeder103513843_feeder
fencer114613533_fencer
fended114216913_fended
fenders113717263_fenders
fielder11217413fielder
finder104020233_finder
flenser1036783flenser
flinder11319873flinder
fomenter1339263fomenter
fonder104120063_fonder
founder114312573founder
funder104016083_funder
gamester1137323gamester
gander84322763_gander
gelder84613713_gelder
genders93616783_genders
grander93315873grander
grinder93312393grinder
hander104526433_hander
header104422543_header
heder95623633_he_der
heeder104216043_heeder
herder104516463_herder
hinder104120063_hinder
hounder113412233hounder
immenser1244173immenser
impeder12438533impeder
impended1435953impended
intender93310443intender
joinder15337593joinder
keener104012833keen_er
kinder113716843_kinder
kneader1275893kneader
lamented1138193lamented
lamenters1137683lamenters
lander74028483_lander
launder8309143launder
lavenders1334753lavenders
leader74824653_leader
lenders84419643_lenders
lewder10479613_lewder
lieder74912323lie_der
madder103515593_madder
maenades1137473maenades
manger94325003_manger
manner84020513_manner
maunders11348343maunders
meager94515193_meager
meanders1168833_meanders
meaner84617843_meaner
meddler11319953_meddler
meeker12359983_meeker
meeter83616503_meeter
melded104714713_melded
melders103213913_melders
melter83520113_melter
member12258853_member
menacer112610883_menacer
mend75334033_mend__
mends84927693_mend_s
menhir1136783_menhir
mense75025633_mense_
mensed93916543_mensed
menses84222453_menses
mentee84121293_mentee
mentor8414363_mentor
mercer105214203_mercer
merde84320123_merde_
merdes94518603_merdes
merer75126233_me_rer
merger95016473_merger
meter75130323_me_ter
metier83517693_metier
mewler113510233_mewler
milder93818453_milder
mincer104017363_mincer
minded103817833_minded
minders103720123_minders
miner76933543_min_er
minter84425103_minter
molder93819273_molder
monde85723143_monde_
mondes94322353_mondes
monger94418333_monger
mudder104413493_mudder
murder93613783_murder
nakeder1254363nake_der
needer73614953_needer
offender1543723offender
oleander936403oleander
omened93711003omen_ed
opener83910993open_er
pander93725523_pander
pended103819013_pended
penner84616663_penner
pinder94523453_pinder
pleader103511753pleader
plunder103810503plunder
pomander1347083pomander
ponder94521693_ponder
pounder103314003pounder
ravener104110733raven_er
reader73628293_reader
redder83918133_redder
reenter73217793reenter
remended123010393remended
reminder113110513reminder
rended84524103_rended
renders83821673_renders
renter64527413_renter
rounder83514603rounder
sander74828533_sander
scended11329873scended
seder64826753_se_der
seeder74320773_seeder
sended85121233_sended
senders83022353_senders
shedder12339323shedder
slander84015443slander
sledder9399203sledder
smearer94110403smearer
smeller94212783smeller
smelter93311913smelter
smolder10327753smolder
sonder73623523_sonder
sounder83315383sounder
speeder103811073speeder
spencer113610973spencer
spenders113211743spenders
spendier1147143spendier
stander84316163stander
sunder74019823_sunder
tailender1044073tailender
tedder83312153_tedder
teener64717503teen_er
teenier72611143teenier
tended83819483_tended
tenders83719723_tenders
tenner64117103_tenner
tenser64919433_tenser
tenter64623933_tenter
thunder1136963thunder
tinder73821803_tinder
treader84113833treader
trended94011763trended
trendier937913trendier
unamended1344853unamended
under64624213__under
unended92811823unended
unmended12299093unmended
upended11267323upended
vended114416353_vended
vendee105617263_vendee
venders113717003_venders
vendor10359803_vendor
veneer94511693_veneer
venter94218723_venter
wakener1446913waken_er
wander104423713_wander
wedder113612293_wedder
weeder103315513_weeder
weenier103210803weenier
welder102914413_welder
wended113616153_wended
wielder11197673wielder
wiener94513543wien_er
winder104025263_winder
wonder103617813_wonder
yielder11175113yielder
yonder103214133_yonder
zamindar2042403zamindar
zander163417113_zander

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.1561145455.1
2DLD Change Limit1340273476.33021173.3
3Display Results3473470.1232821.1
 (SQL Overall)1786913476.60927037.5
 
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.