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

58 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
pyralids144581(None) 
pyralid1347981pyralid_
pyramids1645641pyramids
peracids13310072peracids
pyralidid1653642pyralidid
pyralidids1752142pyralidids
pyramid1547512pyramid_
aramids102810513_aramids
bipyramids2051343bipyramids
braids95015693_bra_ids
carabids1338193carabids
cyanids13297933cy_anids
eyelids1135943ey_elids
halids104016133__halids
heralds1137713heral_ds
hyalins13229273hy_alins
hyaloids1545993hy_aloids
hydatids1643833hydatids
hydracids1943843hydracids
hyracoids1844253hyracoids
invalids1244743invalids
ooralis7312553oorali_s
ozalids1794063_ozalids
paraglide1345703paraglide
paraglides1445013paraglides
paranoids1248913paranoids
parotids112610413parotids
peracid12312993peracid_
percoids1339663percoids
peroxids1837453peroxids
piracies12312643piracies
plaids94312443p_la_ids
praline93019743p_raline
pralines102217723p_ralines
praxis154012253p_raxi_s
prebids12399883p_rebids
prelims1139823p_relims
psyllids1443023psyllids
ptyalins1364693ptyalins
purlins93415423pur_lins
pyramidal1744013pyramidal
pyramided1873833pyramided
pyramidic1943773pyramidic
pyranoid1447283pyranoid_
pyrans11411063pyra__ns
pyrenoids1544803pyrenoids
pyrexias20224993pyrexias
pyrolas1239863pyrol_as
pyrolize2248133pyrolize
pyrolizes2347233pyrolizes
pyrosis12411653pyrosi_s
pyrrhics1842633pyrrhics
raids65827513__ra_ids
ranids75118703__ranids
rapids94913893__rapids
sialids839723_sialids
syrphids1744243syrphids
upbraids1343553upbra_ids

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 Filter1786911461620.423422437.4
2DLD Change Limit146162586.39022873.6
3Display Results58580.0331757.6
 (SQL Overall)178691586.84626101.5
 
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.