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

248 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
amerced125652(None) 
amerce10310511amerce_
amercer1146371amercer
amerces1149851amerces
aeried74221862a_eried
alerted82512222alerted
amended11328312amended
amercers1256132amercers
arced88224162a__rced
averred11237592averred
averted112211612averted
coerced1238582coerced
emerged11158212emerged
emersed10138512emersed
mercer105214202_mercer
merces105720742_merces
merged104214952_merged
pierced12347592pierced
smerked14327282smerked
tierced10347052tierced
abduced1374843abduced
abetted1058323abetted
aborted10310423aborted
accrued1233823accrued
aced79540883a___ced
acerated113113983acerated
acerber1135243acerber
acorned10238273acorned
acred87126353a_cr_ed
adduced1274353adduced
adeemed1145393adeemed
adhered1239233adher_ed
admired1135703admir_ed
adored84714243ador_ed
adorned9256893adorned
adverted1336103adverted
aerated85322373a_erated
aerie54634603a_erie_
aerier64823153a_erier
aeries64737783a_eries
afeared1176833afeared
agented939423agented
agreed84712503a_greed
aired66032923a_ir_ed
airted74214503a_irted
alarmed1037733alarmed
alerter72111513alerter
altered83215733alter_ed
amassed10388633amassed
amazed18519313am_azed
amberies122514683amberies
amberoid1346433amberoid
ambled115116373am_bled
ambries111614553ambries
ambroid1238883ambroid
amebae1049633amebae_
ameboid1277233ameboid
ameer75618983ame__er
amend85717753ame__nd
amender10349613amender
amercing1337193amercing
amesace1147733amesace_
amesaces1246693amesaces
amice96122873am_ice_
amices105018013am_ices
amped104820513am__ped
ampere10514413amper_e_
amperes11313983amper_es
amused94412513am_used
aneared8512743aneared
aneled74719283ane_led
aneroid8314003aneroid
angered93013473anger_ed
apercu1057383aperc_u
apercus1136573apercus
aperies9423203aperies
arched125717323a__rched
arcked136211943a__rcked
armed86324433a__rmed
armored102610473armor_ed
aspersed11428293aspersed
asserted957903asserted
avenged1245503avenged
averaged1356213averaged
averse95811183averse_
averter102410553averter
awarded1236223awarded
bermed115217723_bermed
cadenced1435523cadenced
cambered15129003camber_ed
cameoed1238383came_oed
camerae11312063camerae_
capered123014043caper_ed
catered103117773cater_ed
caverned1436163caverned
cered85227443_cer_ed
clerked14326653clerked
coerce10310403coerce_
coercer1138383coercer
coerces11311943coerces
commerced18125463commerced
deiced104214483_deiced
demerged13157603demerged
deuced104112123_deuced
embraced15106673embraced
embrued1235293embrued
emended11329603emended
emerald1046923emerald
emerge91510463emerge_
emerges101310883emerges
emeries91620023emeries
emerod9139213emer_od
emeroid101511183emeroid
erred65915673__erred
everted112711853everted
exerted152210053exerted
farced125216533_farced
fenced124412713_fenced
fierce11348913fierce_
fiercer12356953fiercer
fleeced13358153fleeced
forced126316523_forced
hammered16218853hammer_ed
hampered16239933hamper_ed
havered144011453haver_ed
herbed123513453_herbed
herded114215643_herded
homered133212713homer_ed
imbrued1234693imbrued
immerged1444023immerged
immersed1344833immersed
jeered143912793jeer_ed
jereed144012073_jereed
jerked18479593_jerked
kerbed13339703_kerbed
kerfed14358233_kerfed
kerned114112933_kerned
lagered92311153lager_ed
lamented1138193lamented
layered11259413layer_ed
leered73816223leer_ed
maced108528693_m_aced
mammered12237653mammer_ed
marcel103714853_marcel
marched153813403_marched
marked133921623_marked
marled95523163_marled
marred95421043_marred
married104715303married
marted94425213_marted
meated94222403_meated
meed74934703_me__ed
melded104714713_melded
melled95023023_melled
melted94219063_melted
menaced122710093_menaced
mended104418683_mended
mensed93916543_mensed
meoued9118533_meoued
meowed12148003_meowed
merc87225623_merc__
mercers114412773_mercers
mercery14397623_mercery
merch125417963_merc_h
merches144013763_merches
mercies113817563_mercies
mercs96020453_merc_s
mercy125916183_merc_y
merde84320123_merde_
merdes94518603_merdes
mere67244443_mer_e_
merer75126233_mer_er
meres75143573_mer_es
merge84523693_merge_
mergee94018143_mergee
merger95016483_merger
merges94122493_merges
merited10313853_merited
merle75824373_merle_
merles85322763_merles
mermen10813813_mermen
meshed124415933_meshed
messed95018183_messed
meted85424433_me_ted
metred95315143_metred
mewed115218013_me_wed
mewled123710053_mewled
minced114114913_minced
mired85729223_mir_ed
mured85726703_mur_ed
nerved104111683_nerved
omened93711003ome_ned
overbed132811853overbed
overed102216623over_ed
overfed142510253overfed
pampered15229233pamper_ed
papered122513173paper_ed
peaced115818913_peaced
peered93819493peer_ed
perched154713243_perched
perked134617693_perked
permed115217353_permed
pieced113912103pie_ced
pierce104010393pierce_
piercer11337773piercer
pierces113411193pierces
queried1738683queried
remerged12149173remerged
sabered103213023saber_ed
sered65737293_ser_ed
serged84118773_serged
served104616813_served
smarted105012613smarted
smeared104510623smeared
smeeked14287223smeeked
smelled103511853smelled
smelted10399093smelted
smirched1634673smirched
smirked14307233smirked
sourced1038453sourced
specced14266703specced
swerved1455703swerved
tabered103311593taber_ed
tampered13279463tamper_ed
tapered102612933taper_ed
terce75721843_terce_
tercel83612993_tercel
terces83921413_terces
tercet83624913_tercet
termed94816703_termed
tierce8339843tierce_
tiercel9316203tiercel
tierces93710453tierces
tiered73613973tier_ed
tumesced1343523tumesced
umbered121510113umber_ed
vambraced1942403vambraced
veered103612743veer_ed
verged114815163_verged
versed104515513_versed
wafered14288433wafer_ed
wagered12299333wager_ed
waterbed1436443waterbed
watered113014953water_ed
wavered142910433waver_ed
yammered16225763yammer_ed
yerked14509373_yerked
zeroed16409413_zeroed

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.453394461.4
2DLD Change Limit1340272486.03022226.7
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.57627173.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.