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

77 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
atony8721885(None) 
agony96415651agony
astony9510521astony
atomy107415191atomy
atone56527981atone
atopy106813391atopy
stony85818641stony
tony75635151_tony
aeon45634612aeon_
aeons57624652aeons
agon56531882agon_
agone65924552agone
agons66423782agons
ahoy101919182aho_y
alone55732962alone
along65419492along
among85813302among
annoy869712annoy
anomy105113392anomy
anon46134852anon_
anonym1136382anonym
antonym1246512antonym
any68440492a__ny
ataxy1537312ataxy
atoll57913922atoll
atom67824522ato_m
atoms76817562atoms
atonal6514022atonal
atoned75417542atoned
atoner64817192atoner
atones65225772atones
atonia63816512atonia
atonic83420472atonic
atop66124752ato_p
autonym1246632autonym
awny105919302a_wny
axon115524302axon_
axone125918472axone
axons125517932axons
azon135725052azon_
azons146518252azons
barony115915302barony
baton75822422baton_
batons85519422batons
betony114211582betony
bony96732082_bony
cony96537832_cony
crony105918672crony
ebony104511512ebony
goony95519782goony
irony85015902irony
loony86918962loony
mony96830012_mony
moony104818272moony
peony105717562peony
phony136715442phony
pony96434052_pony
ratany93411872ratany
satiny93817982satiny
saxony1636232saxony
stogy95414082stogy
stone55431182stone
stoney96217352stoney
story86723032story
tawny114713652tawny
tiny76134632_tiny
toby96322292_toby
tody86327212_tody
ton310265102_ton_
tone46953742_tone
toney86027412_toney
tong56434352_tong
tons46553052_tons
tory75840542_tory
towny116114492_towny
towy105325472_towy
toy69655192_to_y

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.313570897.8
2DLD Change Limit53800771.67032215.6
3Display Results77770.0164812.5
 (SQL Overall)178691771.99989390.2
 
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.