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

251 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
amending1230891(None) 
emending12298891emending
mending114018681_mending
agenting1039382agenting
amandine1148552amandine
amercing1337192amercing
appending1536282appending
ascending1336282ascending
attending11136372attending
avenging1345862avenging
bending114420892_bending
blending12249962blending
ending83220252__ending
fending123717602_fending
impending1535932impending
lamenting1237692lamenting
lending94118532_lending
melding113414272_melding
mendings12338302_mendings
mensing103915102_mensing
minding113317892_minding
omening10310092omen_ing
pending114119772_pending
remending132311312remending
rending93924262_rending
scending122610582scending
sending94221372_sending
shending132511252shending
spending122712432spending
tending94419162_tending
trending103012832trending
unending10239942unending
upending12258132upending
vending124015262_vending
wending123816842_wending
abegging1334483abegging
abetting1158293abetting
abiding11510503a_biding
aboding11410123a_boding
abounding1335193abounding
abrading1239503abrading
absenting1236993absenting
acceding1446093acceding
accenting1487823accenting
adding93914963a__dding
adeeming1254793adeeming
adenine8311213aden_ine
aedine73218393a_e_dine
ageing84213403age__ing
agenizing2046333agenizing
agentings1134443agentings
aiding84423613a__iding
alerting91312383alerting
aliening91510893alien_ing
alimenting1344503alimenting
alining81917043alin_ing
alluding1036953alluding
almandine1245393almandine
amassing1138003amassing
amazing1938813am_azing
ambling121411793am_bling
amend85717753amend___
amended11328313amend_ed
amender10349613amend_er
amenders11288353amenders
amendment1445463amendment
amends94713283amend__s
amenity1238333amen_ity
amentia9310153amenti_a
amentias1039413amentias
amidin94015673am_idin_
amidine103613853am_idine
amidins103713103am_idins
amounting1236643amounting
amping114317573am__ping
amusing1039383am_using
anearing9413973anearing
aneling82719503ane_ling
annexing1635473annexing
anting75827023a__nting
arcading1239763arcading
assenting1038163assenting
atoning83514873aton_ing
attendings12143523attendings
auding83616933a__uding
augmenting1443853augmenting
averring12239063averring
averting122512733averting
avoiding1336783avoiding
awarding1356043awarding
aweing103911253awe__ing
awning105013393a_wn_ing
banding114921413_banding
bartending1444913bartending
beading113221863_beading
bedding124114483_bedding
bielding12237473bielding
binding113819383_binding
bleeding12359053bleeding
blinding123210163blinding
bonding113318433_bonding
bounding123012133bounding
branding122513683branding
breading123515463breading
breeding123411843breeding
cadencing1544963cadencing
cameoing1379063came_oing
ceding104014803_ce_ding
cementing1438763cementing
censing104215263_censing
commending1846633commending
damning114211633dam_n_ing
dampening1535463dampen_ing
davening13258873daven_ing
deeding103315123_deeding
defending15298353defending
demanding14237923demanding
dementing13311043dementing
denning93515173_denning
denting94422183_denting
denuding1137113_denuding
denying123711293_denying
depending14208783depending
diamonding1543643diamonding
dreading113712803dreading
embedding1643313embedding
emendating1444613emendating
emerging1237893emerging
endings92910443__endings
enduing9249723__enduing
evening11310223even_ing
expending2045933expending
extending1835853extending
feeding123515073_feeding
fencing132411133_fencing
feuding123410263_feuding
fielding13206863fielding
finding124116543_finding
flensing1246973flensing
fomenting1537233fomenting
fonding123815423_fonding
founding133010793founding
friending1495553friending
funding124113663_funding
garmenting1445483garmenting
gelding103911793_gelding
grinding1139863grinding
handing123518893_handing
havening15258553haven_ing
heading122919113_heading
heeding123515063_heeding
henting113719653_henting
herding122915123_herding
hounding132610053hounding
imbedding1643243imbedding
impeding1436563impeding
intending1139983intending
keening123713153keen_ing
kenning124010543_kenning
kneading1436373kneading
ladening1078823laden_ing
landing92819323_landing
latening9711493laten_ing
leading93419553_leading
lensing84015103_lensing
madding123711993_madding
manning103616383_manning
meaning103918703_meaning
meddling13257933_meddling
medina94114093_me_dina
meeting103314963_meeting
melling102822623_melling
melting103317753_melting
menacing1339783_menacing
mendigo11506333_mendigo
meninx1538703_men_inx
meouing1059203_meouing
meowing1368593_meowing
merging112711763_merging
meshing134513813_meshing
messing103916393_messing
meting94320593_me_ting
metring103215293_metring
mewing123914203_me_wing
mewling13329513_mewling
milding113615453_milding
mincing123314333_mincing
mining94225453_min_ing
minting103020813_minting
molding114213753_molding
mounding123311263mounding
mudding123310813_mudding
munting103718773_munting
needing93214423_needing
nonending1138003nonending
offending1744093offending
opening1039923open_ing
parenting12611583parenting
patenting1248943patenting
peening103318303peen_ing
penning103616493_penning
pleading123011443pleading
poinding122510003poinding
ponding114317083_ponding
pounding123311473pounding
ravening122611293raven_ing
reading93327213_reading
redding103218513_redding
reding83825563_re_ding
reeding94124133_reeding
relending112412023relending
remanding132211143remanding
reminding132311543reminding
renting84026853_renting
resending112313363resending
rounding102812283rounding
sanding93520603_sanding
scenting113212813scenting
seeding93719483_seeding
sensing84116953_sensing
shedding14278113shedding
sledding11248503sledding
smearing113511753smearing
smeeking15317833smeeking
smelling113712723smelling
smelting11339713smelting
smerking15258473smerking
snedding11246953snedding
sounding102712873sounding
speeding122810933speeding
standing103413633standing
steading103613593steading
sueding92613753sue_ding
tedding103210883_tedding
tensing84616653_tensing
tenting84621153_tenting
treading103515333treading
unbending1337463unbending
upsending1334903upsending
venging123710943_venging
venting114218093_venting
wakening1636323waken_ing
wedding133411873_wedding
weeding123815213_weeding
weening114113973ween_ing
welding123213253_welding
wielding13286863wielding
winding123517913_winding
wounding13249403wounding
yenning11369493_yenning
yielding13205033yielding

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.410435831.7
2DLD Change Limit1461622516.51322441.6
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.01625469.1
 
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.