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 “amend” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
amend8571775(None) 
amen66733151amen_
amends94713281amends
amens75624841amens
ament76036541ament
emend86214891emend
mend75334031_mend
abed79734132abe_d
aced79540882ace_d
acned87520672acned
addend9458452addend
admen84516182admen_
aged67334252age_d
agenda837252agenda
agene65621582agene
agent65829642agent
ahead96817052ahead
ahed89536252ahe_d
aimed85626052aime_d
akene95818662akene
aland65526412aland
almond91410432almond
ameba9312382ameba
ameer75618982ameer
amended11328312amended
amender10349612amender
aments85219802aments
amid77036352am_id
amin66042252amin_
amine75835382amine
amino75425502amino
amins75534322amins
among85813302among
amped104820512amped
and47244172a__nd
anent54931842anent
aped78538152ape_d
append1138272append
arena55323812arena
arene55329412arene
armed86324432arme_d
ascend9429732ascend
attend7258972attend
augend837632augend
avens86419332avens
awed88436032awe_d
awned96615952awned
axed128829612axe_d
axmen145112272axmen_
bend76435262_bend
blend85317452blend
damned104212912damned
emends95711432emends
end46834352__end
famed115928342fame_d
fend84832972_fend
fiend95312982fiend
gamed95126392game_d
impend11478792impend
lagend838742lagend
lamed85235292lame_d
lament85024942lament
lend56233672_lend
maenad939412maenad
maned86634102maned
maund85515452maund
mead75531602_mead
med66146742_me_d
meed74934702_meed
meld75830472_meld
men59252852_men_
menad85918982_menad
mends84927692_mends
meno66031362_meno
menu65130232_menu
mind75434382_mind
named85223062name_d
omen66828182omen_
omened93711002omened
omens75618962omens
pend75934532_pend
ramen75625192ramen_
remend95216552remend
rend56136572_rend
scend85516292scend
send55237292_send
shend94719972shend
spend85619332spend
tamed85528512tame_d
tend56433772_tend
trend64817452trend
upend85011042upend
vend86626422_vend
wend85330452_wend
yamen104115182yamen_
yamens114010822yamens

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit53800961.75030742.9
3Display Results96960.0332909.1
 (SQL Overall)178691962.10984727.8
 
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.