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

87 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
pogonia104893(None) 
oogonia846481oogonia
pogonias1148511pogonias
pogonip1245371pogonip
begonia1047212begonia
gonia64117532__gonia
logania847832logania
oogonial945252oogonial
pogonips1344382pogonips
agonic93515143_agonic
ammonia1148693ammonia
aphonia122711883aphonia
apologia1147723apologia
ascogonia1253233ascogonia
atonia63816513_atonia
begonias1146263begonias
bignonia1144233bignonia
boltonia1045513boltonia
boronic11311163boronic
bosonic1139213bosonic
carpogonia1552883carpogonia
cogon89120903cogon__
cogons96818113cogon_s
coloni85619203coloni_
colonial10411343colonial
colonic115015713colonic
corona83817403coron_a
epigoni1056093epigoni_
epigonic1346723epigonic
epopoeia1254673epopoeia
eugenia847713eugenia
gonif94320923__gonif
goonie73615563go_onie
gorgonian1142753gorgonian
hypotonia1747453hypotonia
isogonic11187253isogonic
loggia8457053log_gia
logia68116603log__ia
logoi69715943logo_i_
logon615922313logon__
logons79818173logon_s
loonie64216453lo_onie
mahonia1238443mahonia
moronic11311863moronic
myotonia1346273myotonia
oogonium1144733oogonium
opsonic1137253opsonic
opsonin946013opsonin
ovonic11288183_ovonic
ozonic17308943_ozonic
pagoda10487873pago_da
peloria9310953peloria
pennia84412973p_ennia
peponida1345183peponida
petunia966803petunia
phelonia1347043phelonia
phobia13278603p_hobia
phonic133315213p_honic
phoronid1449073phoronid
photonic15312103photonic
photopia1549733photopia
pignolia1144383pignolia
pignora10306363pignora
pionic103515953p_ionic
pleonic1139433pleonic
pocosin1169643pocosin
podia8415283p__odia
polenta9310093polenta
pollinia1046803pollinia
polonium1248333polonium
polynya1544063polynya
pooing93820683po_oing
poon67341263po_on__
poons75430973po_on_s
poori74816233po_ori_
pooris83916843po_oris
progeria1147943progeria
protonic12314593protonic
pygidia1444193pygidia
pyogenic1648583pyogenic
somoni8310743somoni_
sporogonia1352803sporogonia
syconia1248313syconia
toonie63617993to_onie
valonia1048303valonia
yogini10449143yogini_
yoginis11457683yoginis

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 Filter1786911340270.390458182.1
2DLD Change Limit134027876.34321129.9
3Display Results87870.0302900.0
 (SQL Overall)178691876.76326421.9
 
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.