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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
ament7603654(None) 
agent65829641agent
amen66733151amen_
amend85717751amend
amens75624841amens
aments85219801aments
anent54931841anent
lament85024941lament
abet610547942abe_t
absent84016992absent
accent105116262accent
adept81219642adept
admen84516182admen_
advent102613752advent
agene65621582agene
agents74816292agents
ailment9314232ailment
akene95818662akene
alant55742292alant
alert54740652alert
aliment9316702aliment
ambient11310092ambient
ambit94223712ambit
ameba9312382ameba
ameer75618982ameer
amends94713282amends
amenity1238332amenity
amentia9310152amentia
amin66042252amin_
amine75835382amine
amino75425502amino
amins75534322amins
among85813302among
amort75832202amort
amount8414482amount
anenst63514982anenst
ant37270792a__nt
ardent73022612ardent
arena55323812arena
arene55329412arene
argent74023662argent
armet76739452arme_t
arpent84822092arpent
ascent84519652ascent
assent65119952assent
attent62818322attent
augment10910202augment
aunt46553652a_unt
avant86224662avant
avens86419332avens
avert86029492avert
axmen145112272axmen_
bent67759912_bent
blent76230952blent
brent75734132brent
cadent94120362cadent
cement103321672cement
cent67451012_cent
dement93825152dement
dent57158412_dent
emend86214892emend
event85924442event
foment113718302foment
gamest94919932gamest
garment10315232garment
gent56954392_gent
hent76656382_hent
kent86846962_kent
lambent113711302lambent
laments94314852laments
lamest84722762lamest
latent64124302latent
lent46360532_lent
loment84021472loment
meant76537212_meant
meat66359602_meat
meet65350552_meet
melt65752892_melt
men59252852_men_
mend75334032_mend
meno66031362_meno
menta74424422_menta
menu65130232_menu
met56072432_me_t
mint66758062_mint
moment103319682moment
omen66828182omen_
omens75618962omens
omenta83411722omenta
parent83230422parent
patent84524922patent
payment14310702payment
pent66559072_pent
raiment9315412raiment
ramen75625192ramen_
ramenta9311182ramenta
ramet75743142rame_t
rent46661242_rent
sarment9318762sarment
scent75831622scent
sent46963012_sent
shent85933502shent
smelt74726782smelt
spent75532832spent
stent55634512stent
talent6323322talent
tamest85721292tamest
tent46159862_tent
varment12313242varment
vent76049052_vent
went76051872_went
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.296603685.8
2DLD Change Limit538001131.65632487.9
3Display Results1131130.0303766.7
 (SQL Overall)1786911131.98290156.9
 
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.