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

47 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
pyrexias2022499(None) 
pyrexia19225461pyrexia_
pyrexial20234961pyrexial
prexies163415002p_rexies
pyaemias1545062pyaemias
pyemias1436802py_emias
pyrexes19305832pyrex_es
pyrexic21235352pyrexi_c
alexias14249793_alexias
anorexias1644393anorexias
apraxias1746333apraxias
atresias839473atresias
dyslexias2072363dyslexias
hypoxias2346133hypoxias
pareiras1038183pareiras
paresis93315093paresi_s
paretics122312443paretics
pereia85217983pere_ia_
peroxids1837443peroxids
praxis154012253p_raxi_s
preaxial1746973p_reaxial
prebids12399873p_rebids
precis103416703p_reci_s
predial103815413p_redial
prelims1139823p_relims
premies113823063p_remies
premiss113513813p_remiss
prexes154915943p_rex_es
proxies163014933p_roxies
pyaemia1445733pyaemia_
pyemia1337553py_emia_
pyralids1445803pyralids
pyramids1645643pyramids
pyrenes123511223pyre_nes
pyrenoids1544803pyrenoids
pyres105523883pyre___s
pyretic143210783pyreti_c
pyrex175211213pyrex___
pyrolas1239863pyr_olas
pyrosis12411653pyrosi_s
pyrrhics1842623pyrrhics
pyurias1236703py_urias
pyxies18338293py__xies
pyxis17458633py__xi_s
redias74523603__redias
uremias9249503_uremias
viremias1345873viremias

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.1701051123.5
2DLD Change Limit146162477.89018525.0
3Display Results47470.0331424.2
 (SQL Overall)178691478.09322079.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.