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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
pyknic173489(None) 
pyknics1842481pyknics
cyanic133110772cyanic
cynic124712422cy_nic
hyenic1438722hyenic
hypnic1637262hypnic
panic93923902p_anic
phonic133315212phonic
pianic103714122pianic
picnic123410262picnic
pionic103515952pionic
pyemic1537892pyemic
pyic116915822py__ic
pyknotic1944202pyknotic
pyric123815072py_ric
yonic105920842_yonic
acinic104713543acinic
aeonic83517043aeonic
agonic93515143agonic
aminic104413513aminic
amnic95516243_amnic
aphonic142713393aphonic
atonic83420473atonic
axenic154210003axenic
axonic154312723axonic
azonic175513153azonic
bionic103614573bionic
byrnie11348573byrnie
clinic104312793clinic
clonic104914673clonic
conic95329793_conic
cryonic1437833cryonic
cyanid123912043cyanid
cyanin113911453cyanin
cyclic1238033cyclic
cynics13377363cy_nics
cystic132710653cystic
dyadic1336093dyadic
dyking15458013dyking
edenic9310223edenic
ethnic1148853ethnic
exonic153211413exonic
genic85119393_genic
hyaenic1545993hyaenic
hydric15227953hydric
iconic10411593iconic
ionic74622663_ionic
irenic8311103irenic
ironic8313773ironic
kaonic1238763kaonic
knit85728143__knit
limnic10418843limnic
lyric104512723ly_ric
lytic104513033ly_tic
manic94629443_manic
muonic10410183muonic
myopic15308463myopic
myotic133112313myotic
mystic132711643mystic
mythic1637273mythic
opsonic1137253opsonic
ovonic11288183ovonic
ozonic17308943ozonic
panics103815363p_anics
paynim1337363paynim
pectic122913873pectic
pekin111514423pek_in
pekins121812233pekins
pelvic13307553pelvic
penis75129323p_enis
penni74617903penni_
pennia84412973pennia
pennis84315743pennis
peptic122113153peptic
pernio8513143pernio
phasic133612053phasic
phatic133014413phatic
phenix1837133phenix
phobic153010073phobic
phonics143110723phonics
photic133316443photic
phrenic1438773phrenic
phylic16279553phylic
physic16288473physic
phytonic1848203phytonic
pic76046823p___ic
picnics13297343picnics
picric12309923picric
piki106520563pik_i_
piking133719643piking
pikis115116393pik_is
pinkie124414273pinkie
pleonic1139433pleonic
poetic10416843poetic
poking133819303poking
polyenic1547673polyenic
psychic1944833psychic
ptotic102713373ptotic
pubic114513723p_ubic
public12238143public
pudic104614563p_udic
puking133913063puking
punkie123513613punkie
punkin123611523punkin
puranic11410483puranic
pyaemic1645873pyaemic
pycnotic1745823pycnotic
pyemia1337553pyemia
pyin96823233py__in
pyins105815863pyin_s
pyknosis1753643pyknosis
pyloric1438063pyloric
pyogenic1648583pyogenic
pyoid11513763py_oid
pyosis114012123pyosis
pyretic143210783pyretic
pyrexic21235353pyrexic
pyridic15267833pyridic
pyritic143311313pyritic
pyrrhic1744073pyrrhic
pythonic1847553pythonic
pyuria1136953pyuria
pyxie17359363py_xie
pyxis17458633py_xis
quinic17319473quinic
reknit10312533reknit
runic73615773_runic
ryking14348113ryking
scenic10510513scenic
sonic75225293_sonic
sphenic1449093sphenic
splenic1148663splenic
sync95415103sy_n_c
syndic1237303syndic
tannic82811483tannic
tonic74727653_tonic
tunic74018223_tunic
typic124511963ty_pic
tyronic1239313tyronic
unknit1068593unknit
uranic82315183uranic
vinic10314973_vinic
xenic144114643_xenic
yogic116114933_yogic
yoni77524393_yoni_
yonis85020823_yonis

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161465.14021929.2
3Display Results1461460.0463173.9
 (SQL Overall)1786911465.56232127.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.