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

90 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
hyaenic154599(None) 
hyenic1438721hy_enic
cyanic133110772cya_nic
haemic133210082h_aemic
hyaena1235362hyaen_a
hyaenas1334982hyaenas
hygienic1742832hygienic
hymenia1546392hymenia
hyphenic2147012hyphenic
hypnic1637262hy_pnic
pyaemic1645872pyaemic
aeonic83517043__aeonic
amnic95516243__amnic
anaemic1149903anaemic
arsenic939323arsenic
axenic154210003_axenic
cyanid123912043cya_nid
cyanin113911453cya_nin
cynic124712423cy__nic
dyadic1336093dya_dic
dysgenic1544283dysgenic
edenic9310223_edenic
eirenic939003eirenic
ethylenic1753123ethylenic
eugenic1038603eugenic
galenic1038693galenic
genic85119393__genic
gynecic1584353gynecic
haeing104118923h_aeing
haemin113412663h_aemin
haen76229453h_aen__
haptenic1545763haptenic
haptic13511893h_aptic
hebetic1438633hebetic
hedonic1339043hedonic
hemic125718623h__emic
heretic12314833heretic
hetaeric1346763hetaeric
homeric14312213homeric
hyalin122210043hya_lin
hyaline132310723hyaline
hyalins13229273hyalins
hyaloid1439073hyaloid
hydric15227953hy_dric
hydronic1748093hydronic
hyena11810253hy_en_a
hyenas1288953hy_enas
hyenine1336953hy_enine
hyenoid1448613hy_enoid
hygienics1851833hygienics
hymen13311043hymen__
hymenal1545203hymenal
hymenial1645313hymenial
hymenium1874773hymenium
hymens1437993hymen_s
hypoxic2466283hypoxic
hysteric1647533hysteric
irenic8311103_irenic
kaonic1238763_kaonic
manic94629443_ma_nic
myalgic15134223myalgic
myogenic1647093myogenic
oceanic1146163oceanic
oxygenic2143793oxygenic
panic93923903_pa_nic
phrenic1438773phrenic
phyletic1847213phyletic
phytonic1848203phytonic
pianic103714123pia_nic
pyaemia1445733pyaemia
pyemic1537893py_emic
pyknic1734893py_knic
pyogenic1648583pyogenic
pyretic143210783pyretic
pyrexic21235353pyrexic
scenic10510513_scenic
selenic9410663selenic
sphenic1449093sphenic
splenic1148663splenic
stannic936663stannic
sthenic1268903sthenic
syngenic1445823syngenic
taenia6313193_taenia
tannic82811483_tannic
tyrannic1344143tyrannic
tyronic1239313tyronic
uraemic1156543uraemic
uranic82315183ura_nic
xenic144114643__xenic
yonic105920843_y_onic

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.406440125.6
2DLD Change Limit134027906.29621287.6
3Display Results90900.0303000.0
 (SQL Overall)178691906.73226543.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.