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 “hemophilics” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
hemophilics236462(None) 
hemophiliacs2462601hemophiliacs
hemophilias2155021hemophilias
hemophilic2256551hemophilic_
hemophiles2047272hemophil_es
hemophilia2056042hemophili_a
hemophiliac2353982hemophiliac
halophilic2054433halophilic_
hemophile1947273hemophil__e
homophiles2048223homophil_es
homophylies2455153homophylies
nemophilas1754523nemophil_as
neophiliacs18123263ne_ophiliacs
neophilias15115733ne_ophilias
pedophilias1953833pedophilias
pedophilic2055003pedophilic_
thermophilic2463973thermophilic_
xerophilies2354993xerophilies
anemophilous1961934anemophilous
basophilias1853244basophilias
basophilic1953954basophilic_
biophilias1754214_biophilias
cryophilic2254324cryophilic_
cytophilic2254974cytophilic_
empirics1444004_em_p_irics
enophiles1448434_enophil_es
geophysics2153484ge_ophysics
halophiles1845884halophil_es
hematinics1743924hem_atinics
hemiplegics21111884hemiplegics
hemopoieses1852824hemopoieses
hemopoiesis1853094hemopoiesis
hemopoietic2053874hemopoietic_
hemoptysis2053714hemoptysi_s
hemostatics1854724hemostatics
homophile1948104homophil__e
homophobias2354734homophobias
homophobic2455654homophobic_
homophonic2256994homophonic_
homophonies2156514homophonies
hydrophilic2555194hydrophilic_
lipophilic1953974lipophilic_
lyophilic1945424_lyophilic_
necrophiliacs2262464necrophiliacs
necrophilias1954084necrophilias
necrophilic2055034necrophilic_
nemophila1654754nemophil__a
neophilia14126304ne_ophili_a
neophiliac17114604ne_ophiliac
oenophiles1545704oenophil_es
pedophiles18105874pedophil_es
pedophilia1854674pedophili_a
pedophiliac2153154pedophiliac
rheophiles1844514rhe_ophil_es
thermophiles2254264thermophil_es
thermophilous2362154thermophilous
toxophilies2353654toxophilies
xenophiles2245424xenophil_es
xerophilous2353294xerophilous
zoophilias2454004_zoophilias
zoophilic2545084_zoophilic_
zoophilies2444804_zoophilies

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819629.25016088.5
3Display Results62620.0302066.7
 (SQL Overall)178691629.70318416.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.