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

182 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
amercing133719(None) 
alerting91312382alerting
amending12308912amending
arcing95819642a__rcing
averring12239062averring
averting122512732averting
coercing1349002coercing
emerging1237892emerging
merging112711762_merging
piercing1346662piercing
smerking15258472smerking
abducing1474063abducing
abegging1334483abegging
abetting1158293abetting
aborning1188003aborning
aborting11710253aborting
accruing1344033accruing
acing87429153a___cing
adducing1384113adducing
adeeming1254793adeeming
adhering1338883adher_ing
admiring1236133admir_ing
adoring9412523ador_ing
adorning1087323adorning
adverting1437223adverting
aerating92821003a_erating
ageing84213403age__ing
agenting1039383agenting
agreeing10295903agreeing
airing74927503a_ir_ing
airting83616303a_irting
alarming1138583alarming
altering91917123alter_ing
amassing1138003amassing
amazing1938813am_azing
amberina1247403amber_ina
ambling121411793am_bling
amerce10310513amerc__e
amerced1256523amerc_ed
amercer1146373amerc_er
amercers1256133amercers
amerces1149853amerc_es
americium1554083americium
amorini9310353amor_ini
amorino9310253amor_ino
amping114317573am__ping
amusing1039383am_using
anearing9413973anearing
aneling82719503ane_ling
angering102113803anger_ing
arching136216693a__rching
arcking145811963a__rcking
arming94719803a__rming
armoring1149123armor_ing
aspersing1237603aspersing
asserting1038663asserting
avenging1345863avenging
averaging1446503averaging
awarding1356043awarding
aweing103911253awe__ing
berming123614833_berming
cadencing1544963cadencing
cambering16109873camber_ing
cameoing1379063came_oing
capering132414963caper_ing
catering112019913cater_ing
caverning1536283caverning
cering94522533_cer_ing
clerking15257163clerking
commercing1955973commercing
deicing11312193_deicing
demerging1436643demerging
deucing1139393_deucing
embracing1645443embracing
embruing1344523embruing
emending12298893emending
erring73816483__erring
everting122213133everting
exerting162211153exerting
farcing133514003_farcing
fencing132411133_fencing
fleecing14347573fleecing
forcing134013753_forcing
hammering1737633hammer_ing
hampering1738863hamper_ing
havering152211053haver_ing
herding122915123_herding
herring113615883_herring
homering141512073homer_ing
imbruing1344003imbruing
immerging1544103immerging
immersing1445123immersing
jeering153513043jeer_ing
jerking19308923_jerking
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
lagering102212313lager_ing
lamenting1237703lamenting
layering122310353layer_ing
leering83417643leer_ing
macing114221553_m_acing
mammering1337333mammer_ing
marching164312193_marching
marking144020133_marking
marling103322773_marling
marring103319553_marring
marrying14157233marrying
marting103325013_marting
meaning103918703_meaning
meeting103314963_meeting
melding113414273_melding
melling102822633_melling
melting103317753_melting
menacing1339783_menacing
mending114018683_mending
mensing103915103_mensing
meouing1059203_meouing
meowing1368593_meowing
mercies113817563_mercies
merino8315093_mer_ino
meriting11314693_meriting
merlin83916683_merlin_
merlins93015813_merlins
meshing134513813_meshing
messing103916393_messing
meting94320593_me_ting
metring103215293_metring
mewing123914203_me_wing
mewling13329513_mewling
mincing123314333_mincing
miring93723803_mir_ing
morning103215043_morning
muring95120373_mur_ing
nerving112910833_nerving
omening10310093ome_ning
overing111918053over_ing
pampering1638383pamper_ing
papering132213313paper_ing
peacing124117073_peacing
peering103520353peer_ing
perching163711633_perching
perking143716463_perking
perming123416093_perming
piecing12410453pie_cing
piercings1453263piercings
quercine1964863quercine
querying2135243querying
remerging1358323remerging
sabering112113743saber_ing
serging93416673_serging
sering74731813_ser_ing
serving113014983_serving
smarting113212453smarting
smearing113511753smearing
smeeking15317833smeeking
smelling113712733smelling
smelting11339713smelting
smirching1744393smirching
smirking15277233smirking
sourcing1158353sourcing
speccing15306643speccing
sterling93615553sterling
swerving1546113swerving
tabering112211423taber_ing
tampering1438453tamper_ing
tapering112112503taper_ing
terming104016003_terming
tiering8315253tier_ing
tumescing1443643tumescing
umbering1399433umber_ing
unerring9311273unerring
veering113213683veer_ing
verging123812303_verging
versing112314193_versing
wafering15208893wafer_ing
wagering13219523wager_ing
watering122316323water_ing
wavering152410543waver_ing
yammering1735193yammer_ing
yerking15368813_yerking
zeroing1738343_zeroing

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621826.83021400.0
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.32924381.4
 
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.