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

112 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
agone6592455(None) 
agene65621581agene
agon56531881agon_
agones75719861agones
agons66423781agons
agony96415651agony
alone55732961alone
atone56527981atone
axone125918471axone
gone55639041_gone
abode85518812abode
above105414322above
acne66625872a_cne
adobe84814712adobe
adore65723672adore
adoze155713832adoze
aeon45634612aeon_
aeons57624652aeons
afore85818602afore
agape85614842agape
agate66525152agate
agave95314032agave
agaze156113662agaze
age47154332ag__e
agee56241492ag_ee
agenes74720252agenes
agent65829642agent
aggie73415012aggie
agile65122262agile
agin56132712agin_
aging77026352aging
aglee65728492aglee
ago48845522ago__
agog68019002ago_g
agonal7410052agonal
agonic93515142agonic
agonies83016622agonies
agonise83112692agonise
agonize172911402agonize
agora6914332agora
agorae7511202agorae
agree65226032agree
ague55725922ag_ue
akene95818662akene
alane56135612alane
aline57243152aline
aloe45540192alo_e
along65419492along
amine75835382amine
amole75724592amole
among85813302among
ancone83916952ancone
ane37866952a__ne
anode65021042anode
anole55330382anole
anon46134852anon_
anyone94612732anyone
arene55329412arene
argon65520592argon_
argons75018202argons
arose55832082arose
atoned75417542atoned
atoner64817192atoner
atones65225772atones
atony87218852atony
awoke124912002awoke
axon115524302axon_
axones134614512axones
axons125517932axons
azine146721412azine
azole145118032azole
azon135725052azon_
azons146518252azons
azote144416342azote
begone9512132begone
bone65949322_bone
bygone1256172bygone
clone75728162clone
cone67256962_cone
crone75231332crone
done55747912_done
drone65324982drone
gane55145302_gane
gene56237222_gene
gonef95221292_gonef
goner66025162_goner
gong66827192_gong
gore55744962_gore
hone77549322_hone
irone55126362irone
krone94018732krone
lagune7158632lagune
leone55018822leone
lone45849132_lone
none45743172_none
one37050912__one
orgone71110912orgone
ozone14310612ozone
phone105621932phone
pone65747532_pone
prone75332622prone
scone74621832scone
shone83725982shone
sone46649982_sone
stone55431182stone
tone46953742_tone
trone55131862trone
wagon94312952wagon_
wagoned1256222wagoned
wagoner1136092wagoner
wagons103911212wagons
zone135231082_zone

Search took 4 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.873204686.1
2DLD Change Limit538001122.67320127.2
3Display Results1121120.0303733.3
 (SQL Overall)1786911123.57649969.5
 
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.