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

56 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
toxemia164487(None) 
toxaemia1743061toxaemia
toxemias1744731toxemias
toxemic1845591toxemic
anoxemia1754772anoxemia
bohemia1446362bohemia
coremia11310362coremia
taxemic1835242taxemic
tonemic11310172tonemic
totemic1137532totemic
toxaemias1842812toxaemias
toxaemic1943562toxaemic
anaemia959803anaemia
anemia82613573_anemia
anoxemias1844543anoxemias
anoxemic1945593anoxemic
azotemia19104173azotemia
bohemian1544763bohemian
bohemias1545983bohemias
codeia94112193code_ia
copremia1445253copremia
godetia945353godetia
hypoxemia2654613hypoxemia
ketonemia1563263ketonemia
lexemic1844283lexemic
lobelia947213lobelia
obelia8329453_obelia
polemic13311253polemic
proxemic2146153proxemic
pyaemia1445733pyaemia
pyemia1337553_pyemia
stokesia1243963stokesia
taenia6313193t_aenia
taxeme1536253taxem_e
taxemes1635853taxemes
telia55821143t__elia
tenia55324483t__enia
toea46732333to_e__a
tomenta9319833tomenta
toneme8312103tonem_e
tonemes9311683tonemes
tonetic9313433tonetic
totem74819373totem__
totemism1245433totemism
totemist1049033totemist
totemite1046873totemite
totems86810763totem_s
toxic145315623tox__ic
toxin124716713tox__in
toxoid1438153tox_oid
uraemia946503uraemia
uremia82910893_uremia
viremia1246083viremia
xenia124814773__xenia
zoecia1735553zo_ecia
zooecia1843843zooecia

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 Filter1786911340270.393454684.5
2DLD Change Limit134027566.40620922.1
3Display Results56560.0134307.7
 (SQL Overall)178691566.81226231.8
 
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.