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

55 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
psyllid134452(None) 
psyllids1443021psyllids
pallid93915282p_allid
phylloid1746192phylloid
psylla1133952psyll_a
psyllas1244882psyllas
psyllium1543032psyllium
amyloid1348543amyloid
eyelid1038443_eyelid
idyllic1342973idyllic
palled94625163p_alled
pallia83015593p_allia
payload1336403payload
phalli1148263phalli_
phallic1447293phallic
phylic16279553phy_lic
phyllite1645743phyllite
phyllo1435873phyll_o
phyllode1743943phyllode
phylloids1844523phylloids
phyllos1535583phyllos
phytoid1678753phytoid
pilled94222753p_illed
plaid85118303p__laid
polled94022003p_olled
prilled104713003prilled
psalmed1234503psalmed
psalmic1345333psalmic
psocid1137253ps_ocid
psyched1843913psyched
psychic1944833psychic
psylliums1642193psylliums
ptyalin1274783ptyalin
pulled94322193p_ulled
pyoid11513763p_y_oid
pyralid1347983pyralid
sallied83316953_sallied
salpid9510883_salpid
sialid7314943_sialid
slid55828983_s__lid
sloid64619713_s_loid
solid65025083_s_olid
spalled103113133spalled
spelled103714733spelled
spilled103613623spilled
stolid74213183_stolid
styloid1137553styloid
sulfid1039063_sulfid
sullied83714483_sullied
syli74318983_sy_li_
sylis84316023_sy_lis
sylphid1645963_sylphid
sylvin12247303_sylvin
waylaid1445093waylaid
xyloid1738193_xyloid

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 Filter1786911340270.423422437.4
2DLD Change Limit134027556.97019229.1
3Display Results55550.0134230.8
 (SQL Overall)178691557.40624127.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.