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

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

81 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
nonagons94722(None) 
nonagon847311nonagon_
monaxons1744812monaxons
nonages8313842nonag_es
nonagonal1055272nonagonal
nonegos837142nonego_s
nonpagans1243832nonpagans
agons66423783___agons
bonbons1139333bon_bons
bongoes104314113bon_goes
bongos95316653bon_go_s
cogons96818113co__gons
conations111318903conations
congoes103617303con_goes
congos94219883con_go_s
congous103615083con_gous
contagions1346603contagions
decagons1235893decagons
donations101112353donations
donators9310403donators
donjons1536733don_jons
dragons938383_dragons
enneagons1042133enneagons
flagons1137973_flagons
fourgons1234833fourgons
gonfalons1342533gonfalons
gonfanons1342363gonfanons
gorgons938853go_rgons
hexagons1943943hexagons
honans94814503hona__ns
ionogens956823ionogens
logons79818173lo__gons
longans84510813lon_gans
menazons1945733menazons
monaxon1644913monaxon_
mongoes103415713mon_goes
mongols103310823mon_gols
mongos94318623mon_go_s
monsoons1047343monsoons
monurons1037093monurons
negatons9299273negatons
ninons64913773nin__ons
noggins9288453no_ggins
nonacids11148263nonacids
nonactions1248373nonactions
nonactors1147873nonactors
nonage7313683nonag__e
nonarts7311303nona_rts
nonas55126653nona___s
nonbooks1446123nonbooks
noncoms1139203non_coms
nonego737013nonego__
nonfans1037533non_fans
nongays11176533non_gays
noniron738373noniron_
nonmajors1843233nonmajors
nonpagan1144413nonpagan_
nonpros937473nonpro_s
nonstops10116883nonstops
nonunions945583nonunions
noons54125283no___ons
notations91512973notations
notions74014483no_tions
novations12139003novations
octagons1144493octagons
onagers838103_onagers
onions64016433_on_ions
paragons11311503paragons
pentagons1246153pentagons
polarons1039863polarons
polygons1447723polygons
pontons93315553pon_tons
pontoons10279313pontoons
ronions73313343ron_ions
rontgens944683rontgens
ronyons10258433ron_yons
synagogs1343273synagogs
synanons1144633synanons
wagons103911213__wagons
wontons103310533won_tons
zonations18139313zonations

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit146162816.33023090.4
3Display Results81810.0302700.0
 (SQL Overall)178691816.76626410.1
 
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.