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

64 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
pyaemia144573(None) 
pyaemias1545061pyaemias
pyaemic1645871pyaemic
pyemia1337551py_emia
anaemia959802anaemia
pyemias1436802py_emias
pyemic1537892py_emic
pyrexia19225462pyrexia
uraemia946502uraemia
academia1345113academia
aecia73819283__aecia
amia66836893__a_mia
anaemias1069193anaemias
anaemic1149903anaemic
anemia82613573_anemia
bohemia1446363bohemia
coremia11310363coremia
gynaecia1442363gynaecia
gynecia1384233gynecia
haemic133210083_haemic
haemin113412663_haemin
hyaena1235363hyae_na
hyaenic1545993hyaenic
hymenia1546393hymenia
hyphemia2146123hyphemia
kalmia1238893_kalmia
lamia75324323_la_mia
myalgia13124283myalgia
mycelia1444823mycelia
paella8410913p_aella
pallia83015593p_allia
pampa114913423p_a_mpa
pereia85217983pere_ia
phasmid15267603phasmid
plasma103810913plasm_a
plasmic13249113plasmic
plasmid12239553plasmid
plasmin112410033plasmin
polemic13311253polemic
praedial1178763praedial
preemie11310563preemie
premie103617993p_remie
premix173710333p_remix
proemial1249183proemial
psalmic1345333psalmic
pygidia1444193pygidia
pyjama20303483pyjam_a
pyramid1547503pyramid
pyretic143210783pyretic
pyrexial20234963pyrexial
pyrexias20224993pyrexias
pyrexic21235353pyrexic
pyuria1136953py_uria
pyxidia2043843pyxidia
sapraemia1353353sapraemia
taenia6313193_taenia
toxaemia1743063toxaemia
toxemia1644873toxemia
uraemias1046043uraemias
uraemic1156543uraemic
uremia82910893_uremia
viremia1246083viremia
yautia937243_yautia
zamia165115213_za_mia

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.1561145455.1
2DLD Change Limit134027646.98619185.1
3Display Results64640.0302133.3
 (SQL Overall)178691647.17224915.1
 
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.