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

198 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
amercer114637(None) 
amerce10310511amerce_
amerced1256521amerced
amercers1256131amercers
amerces1149851amerces
mercer105214201_mercer
acerber1135242acerber
aerier64823152a_erier
alerter72111512alerter
ameer75618982ame__er
amender10349612amender
averter102410552averter
coercer1138382coercer
fiercer12356952fiercer
mercers114412772_mercers
mercery14397622_mercery
merces105720742_merces
merer75126232_mer_er
merger95016482_merger
piercer11337772piercer
abetter958323abetter
aborter939933aborter
adducer1184163adducer
adepter1036113adepter
adherer1137573adher_er
admirer1035523admir_er
adorer74713453ador_er
adorner8246983adorner
aerie54634603a_erie_
aeried74221863a_eried
aeries64737783a_eries
aether94213673a_ether
airer54927893a_ir_er
airier64619363a_irier
alerted82512223alerted
alterer72714003alter_er
amasser9418733amasser
ambeer104511603am_beer
amber94523213am__ber
amberies122514683amberies
ambler104916453am_bler
ambries111614553ambries
amebae1049633amebae_
ameers84015573ame__ers
amelcorn1243223amelcorn
amended11328313amended
amenders11288353amenders
amercing1337193amercing
amesace1147733amesace_
amesaces1246693amesaces
amice96122873am_ice_
amices105018013am_ices
ammeter1148393ammeter
ampere10514413amper_e_
amperes11313983amper_es
ampler104313303am_pler
amuser84712623am_user
angrier839023angrier
apercu1057383aperc_u
apercus1136573apercus
aperies9423203aperies
arced88224163a__rced
archer115016243a__rcher
armer76924443a__rmer
armorer9259913armor_er
asperser10408303asperser
asserter877573asserter
atelier7311623atelier
avenger1135493avenger
averred11237593averred
averse95811183averse_
averted112211613averted
averters11249513averters
awarder1135893awarder
beerier93613023beerier
cameleer1246033cameleer
camerae11312063camerae_
caperer113013403caper_er
caterer92815943cater_er
coerce10310403coerce_
coerced1238583coerced
coercers1237653coercers
coerces11311943coerces
deicer94114413_deicer
demerger12127373demerger
eagerer8248823eager_er
eerier64320023_eerier
embracer1496463embracer
emeer74815363eme__er
emender10649843emender
emerge91510463emerge_
emerged11158213emerged
emerges101310883emerges
emeries91620023emeries
emersed10138513emersed
farcer115016083_farcer
fencer114613533_fencer
fierce11348913fierce_
fierier103511193fierier
fleecer12368033fleecer
forcer114917343_forcer
gamester1137323gamester
hammerer15278143hammer_er
hamperer15379093hamper_er
herder104516463_herder
jeerer13389933jeer_er
jerker17369043_jerker
lamenter1038863lamenter
leerier73111503leerier
macer912126943_m_acer
marcel103714853_marcel
marcher143912973_marcher
marker124420393_marker
marrer83716673_marrer
marrier93817523marrier
meager94515203_meager
meaner84617843_meaner
meeker12359983_meeker
meeter83616503_meeter
melder93915813_melder
melter83520113_melter
member12258853_member
menacer112610883_menacer
mender93520793_mender
merc87225623_merc__
merch125417963_merc_h
merches144013763_merches
mercies113817563_mercies
mercs96020453_merc_s
mercury14364893_mercury
mercy125916183_merc_y
merde84320123_merde_
merdes94518603_merdes
mere67244443_mer_e_
meres75143573_mer_es
merge84523693_merge_
merged104214953_merged
mergee94018143_mergee
mergers103813423_mergers
merges94122493_merges
merle75824373_merle_
merles85322763_merles
mermen10813813_mermen
merrier92612303_merrier
meter75130323_me_ter
metier83517693_metier
mewler113510233_mewler
mincer104017363_mincer
mirier83918363_mirier
mirker123712693_mirker
murder93613783_murder
murker123715243_murker
onerier7311613onerier
pamperer14228333pamper_er
paperer113111903paper_er
percher143313423_percher
perter84422283_perter
piecer105213083pie_cer
pierce104010393pierce_
pierced12347593pierced
piercers12316723piercers
pierces113411193pierces
querier16310013querier
scarcer113911373scarcer
serer55935513_ser_er
serger73819743_serger
server94917713_server
smarter94113133smarter
smearer94110403smearer
smearier1036953smearier
smeller94212793smeller
smelter93311913smelter
smerked14327283smerked
smirker13327423smirker
spencer113610973spencer
sterner7411913sterner
swerver1365733swerver
tamperer12248893tamper_er
taperer92511793taper_er
taverner1134423taverner
terce75721843_terce_
tercel83612993_tercel
terces83921413_terces
tercet83624913_tercet
termer85717253_termer
terser67317823_terser
tierce8339843tierce_
tierced10347053tierced
tiercel9316203tiercel
tierces93710453tierces
verger104315703_verger
verier94620963_verier
verser94516963_verser
wagerer11328493wager_er
waterer103314073water_er
waterier11312083waterier
waverer13319523waver_er
yammerer15225483yammer_er

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.403443402.0
2DLD Change Limit1340271986.03322215.6
3Display Results1981980.0633142.9
 (SQL Overall)1786911986.49927495.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.