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

59 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
phyllite164574(None) 
phyllites1745321phyllites
hyalite13229472_hyalite
phyllitic1944422phyllitic
phyllode1743942phyllode
phyllome1854142phyllome
rhyolite1445512rhyolite
aphyllies1743823aphyllies
apophyllite2162463apophyllite
challie124012853challi_e
cryolite1347503cryolite
fayalite1447053fayalite
ghillie11326353ghilli_e
halite93624233_h_alite
haplite12310703_haplite
hellkite1544933_hellkite
hoplite12311073_hoplite
hyaline132310723_hyaline
hyalites14208833_hyalites
illite63414923__illite
kryolite1544493kryolite
mullite9313013_mullite
ophiolite1444633ophiolite
palliate10311893p_alliate
pearlite1039443pearlite
pelite84323003p__elite
penlite9313243p_enlite
perlite9317323p_erlite
phalli1148263phalli__
phallic1447293phalli_c
phallism1545713phallism
phallist1338993phallist
phallists1445723phallists
phonolite1448283phonolite
phylae14458733phy_l_ae
phyle134111153phy_l__e
phyletic1847213phyletic
phylic16279553phy_li_c
phyllary1943233phyllary
phyllo1435873phyll__o
phyllodes1843823phyllodes
phylloid1746193phylloid
phylloids1844523phylloids
phyllomes1944123phyllomes
phyllos1535583phyll_os
phytolith2064703phytolith
pisolite10310373pisolite
polite83625073p__olite
pollute937383p_ollute
psyllid1344523psylli_d
psyllids1443023psyllids
psyllium1543033psyllium
pyrite11913313p_y_rite
rhyolites1545033rhyolites
stellite839533stellite
stylite10219613sty_lite
stylolite1244383stylolite
sylvite13266353_sylvite
tillite7313563_tillite

Search took 9 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 Filter1786911461620.546327272.9
2DLD Change Limit146162597.90618487.5
3Display Results59590.0301966.7
 (SQL Overall)178691598.48221067.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.