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

82 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
pyknics184248(None) 
pyknic1734891pyknic_
cynics13377362cy_nics
panics103815362p_anics
phonics143110722phonics
picnics13297342picnics
aphonics15259523aphonics
atonics93613713atonics
bionics114310873bionics
byrnies12378573byrnies
clinics11338743clinics
conics103920593_conics
cryonics1555413cryonics
cyanic133110773cyanic_
cyanids13297933cyanids
cyanins122910013cyanins
cynic124712423cy_nic_
dyadics1453473dyadics
ebonics1137193ebonics
ethnics1236263ethnics
hyenic1438723hyenic_
hypnic1637263hypnic_
ionics84214483_ionics
irenics937833irenics
knits93914743__knits
lyrics11357943ly_rics
manics103919933_manics
myotics14257603myotics
mystics14279103mystics
ovonics12245553ovonics
panic93923903p_anic_
paynims1434973paynims
pekins121812233pek_ins
pelvics14245643pelvics
penis75129323p_eni_s
pennies94218813pennies
pennis84315743penni_s
peonies93620153peonies
peptics132610243peptics
phobics16286703phobics
phonic133315213phonic_
phonies123717513phonies
photics142810483photics
physics17265963physics
pianic103714123pianic_
picnic123410263picnic_
pics85633913p___ics
pikis115116393pik_i_s
pinkies133818263pinkies
pinnies93318443pinnies
pionic103515953pionic_
poetics11312073poetics
pokies125921333pok_ies
ponies84833463p_onies
psychics2043823psychics
publics13207143publics
punkies134216803punkies
punkins133111113punkins
pyemias1436803pyemias
pyemic1537893pyemic_
pygmies15205673pygmies
pyic116915823py__ic_
pyins105815863py__ins
pyknoses1783573pyknoses
pyknosis1753643pyknosis
pyknotic1944203pyknotic_
pyosis114012123pyosi_s
pyric123815073py_ric_
pyrrhics1842633pyrrhics
pyurias1236713pyurias
pyxies18338293py_xies
pyxis17458633py_xi_s
reknits1137073reknits
scenics1137773scenics
sonics84315633_sonics
syncs104610173sy_n_cs
syndics1335703syndics
tonics83617863_tonics
tunics83811263_tunics
unknits1135553unknits
yonic105920843_yonic_
yonis85020823_yoni_s

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 Limit134027826.42320866.7
3Display Results82820.0302733.3
 (SQL Overall)178691826.84326113.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.