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

105 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
agent6582964(None) 
agene65621581agene
agents74816291agents
ament76036541ament
anent54931841anent
argent74023661argent
gent56954391_gent
abet610547942abe_t
absent84016992absent
accent105116262accent
adept81219642adept
advent102613752advent
age47154332age__
aged67334252age_d
agee56241492age_e
ageing84213402ageing
ageist7315382ageist
agency1237032agency
agenda837252agenda
agenes74720252agenes
agented939422agented
agentry11165752agentry
ager55935842age_r
agers65027852agers
ages55844592age_s
agin56132712agin_
aging77026352aging
agist66325582agist
aglet65534142aglet
agon56531882agon_
agone65924552agone
agons66423782agons
agony96415652agony
akene95818662akene
alant55742292alant
alert54740652alert
amen66733152amen_
amend85717752amend
amens75624842amens
aments85219802aments
anenst63514982anenst
ant37270792a__nt
ardent73022612ardent
arena55323812arena
arene55329412arene
argents84014852argents
arpent84822092arpent
ascent84519652ascent
assent65119952assent
attent62818322attent
augend837632augend
augment10910202augment
aunt46553652a_unt
avant86224662avant
avens86419332avens
avert86029492avert
bent67759912_bent
blent76230952blent
brent75734132brent
cadent94120362cadent
cent67451012_cent
coagent10313982coagent
cogent9321002cogent
dent57158412_dent
egest65222342egest
event85924442event
gaen57329602gaen_
gaunt65430402gaunt
gelt56448012_gelt
gen45950512_gen_
gene56237222_gene
genet66038682_genet
gens55740072_gens
gents65729612_gents
genu55929072_genu
gest56149132_gest
get47467462_ge_t
hent76656382_hent
kent86846972_kent
lagend838742lagend
lament85024942lament
latent64124302latent
lent46360532_lent
magenta1038622magenta
magnet9320662magnet
margent10316692margent
pageant10312782pageant
parent83230422parent
patent84524922patent
pent66559072_pent
reagent8716602reagent
regent74127672regent
rent46661242_rent
sagest74920262sagest
scent75831622scent
sent46963012_sent
shent85933502shent
spent75532832spent
stent55634512stent
talent6323322talent
tangent8315002tangent
tent46159862_tent
urgent73816042urgent
vent76049052_vent
went76051872_went

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 Limit538001052.03026502.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.35675845.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.