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

74 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
hymenia154639(None) 
hymenial1645291hymenial
hyaena1235362hyaen_a
hyaenic1545992hyaenic
hyena11810252hy_en_a
hyenic1438722hy_enic
hymen13311042hymen__
hymenal1545182hymenal
hymeneal1643472hymeneal
hymenium1874772hymenium
hymens1437992hymen_s
amentia9310153_amentia
ammonia1148693ammonia
amnia75918643_am_nia
bumelia1145263bumelia
camelia11510433camelia
cementa112810533cementa
cymatia1446443cymatia
cymene1377393cymen_e
cymenes1477413cymenes
dementia1157823dementia
eugenia847713eugenia
gynecia1384233gynecia
henna84414043h__enna
hernia9312293h_ernia
himatia1248593himatia
homeric14312213homeric
hominian1357093hominian
hominid13249533hominid
hryvnia1641643hryvnia
humeri1138523humeri_
hyaenas1334983hyaenas
hydria13227903hy_dria
hyenas1288953hy_enas
hyenine1336953hy_enine
hyenoid1448613hy_enoid
hygienic1742833hygienic
hymeneals1742533hymeneals
hymeniums1973473hymeniums
hymn12311313hym_n__
hymnal1434913hym_nal
hymned1535323hym_ned
hymning1635183hym_ning
hymnist1546633hym_nist
hymns1337523hym_n_s
hyphemia2146123hyphemia
hyphenic2147003hyphenic
hypnic1637263hy_pnic
hypomania1946723hypomania
hyponea1546453hyponea
hyponoia1646263hyponoia
hypoxia2246373hypoxia
hysteria1447393hysteria
lomenta92710133lomenta
mania75634153__mania
media84721713__media
menial84223033__menial
mensa75318663__mensa
menta74424423__menta
momenta11299853momenta
mycelia1444843mycelia
omenta83411723_omenta
pyaemia1445733pyaemia
pyemia1337553py_emia
pyrexia19225463pyrexia
ramenta9311183ramenta
splenia948313splenia
sthenia1058503sthenia
syconia1248313syconia
taenia6313193_taenia
tenia55324483__tenia
tomenta9319833tomenta
xenia124814773__xenia
yenta83917043_y_enta

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.1561145455.1
2DLD Change Limit134027746.12321889.1
3Display Results74740.0332242.4
 (SQL Overall)178691746.31228309.7
 
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.