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

63 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
pentagons124615(None) 
pentagon1146321pentagon_
heptagons1543452heptagons
pendragons1452242pendragons
pentagonal1363562pentagonal
pentagonals1462272pentagonals
pentanols1146112pentanols
benthons1337973bent_hons
centavos1344783centavo_s
contagions1346603contagions
decagons1235893de_cagons
dentations11413633dentations
enations83316903_enations
enneagons1042133enneagons
enterons8314153_enterons
estragons1044653_estragons
etalons739073_e_talons
fenthions1544233fenthions
heptagon1443573heptagon_
hexagons1943943he_xagons
martagons1245123martagons
menazons1945733men_azons
mentations12312583mentations
mentions10312893ment_ions
nonagons947223non_agons
octagons1144493_octagons
pantalone1146833pantalone
pantalones1246723pantalones
pantaloons1243613pantaloons
pantheons1446513pantheons
paragons11311503p_aragons
pedagogs13123793pe_dagogs
peltations12311553peltations
pendragon1352283pendragon_
pengos94612413pen__go_s
pennons939713pen__nons
pensions10311693pen_sions
penstemons1452363penstemons
pentacles1338773pentacles
pentads1039523penta__ds
pentagram1444673pentagram
pentagrams1543163pentagrams
pentane9415743penta__ne
pentanes10316083penta_nes
pentangles1344833pentangles
pentanol1046173pentano_l
pentarchs1643933pentarchs
pentathlons1652323pentathlons
pentatonic1454683pentatonic
pentosans1145183pentosans
perigons11310083pe_rigons
pertains102113423perta_ins
petalous1058973pe_talous
petasos948603pe_taso_s
pintadoes1295253pintadoes
pintados11105993pintado_s
pintanos10107553pintano_s
pontons93315553pont__ons
pontoons10279313pont_oons
tentages91011043tentag_es
tetragons1045353tetragons
venations12311723venations
ventages12119773ventag_es

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641637.20320636.0
3Display Results63630.0302100.0
 (SQL Overall)178691637.65623340.0
 
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.