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

95 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
hyphae174643(None) 
hypha1637381hypha_
hyphal1736411hyphal
hydrae13258572hydrae
hype125519812hyp__e
hyphen1736392hyphen
nymphae1743832nymphae
raphae114311732raphae
rhaphae1543192rhaphae
alpha1049653alpha_
alphas1139513alphas
byplay1634193byplay
cymae126713013cy_mae
cypher16306593cypher
daphne12237013daphne
diphase1387273diphase
epha9310053_epha_
ephah1337063_ephah
ephas10311543_ephas
hae67364003___hae
haha107821063h_aha_
hahas117118443h_ahas
hapax1739323hap_ax
heehaw1543933heehaw
hepcat13611823hepcat
heptad1237273heptad
heptane1238363heptane
hermae115314473hermae
hippie132811243hippie
hope96639673hop__e
hophead16337923hophead
hopple132910483hopple
huppah1644183huppah
hydra12249223hydra_
hydras13239313hydras
hydrase14287663hydrase
hydrate14239813hydrate
hydriae14246903hydriae
hyena11810253hyena_
hyenas1288953hyenas
hyetal1236543hyetal
hyla106716513hy_la_
hylas114815903hy_las
hymnal1434913hymnal
hyp117822463hyp___
hyped145313333hyp_ed
hyper135213903hyp_er
hypers144811913hypers
hypes135818673hyp_es
hyphenate2044503hyphenate
hyphened2044683hyphened
hyphens1836043hyphens
hyping15408483hyping
hypnic1637263hypnic
hypo127516353hyp__o
hypoed1547923hypoed
hypogea1645473hypogea
hyponea1546453hyponea
hypos1312014743hyp_os
hyps125418413hyp__s
hyrax1838033hy_rax
hyte109018943hy__te
imphee13310353imphee
inphase1245383inphase
kythe15509673kyth_e
lychee143710893lychee
lyttae994713lyttae
nuchae11218513nuchae
nympha1643573nympha_
nymphal1744033nymphal
orphan1137733orphan
ouphe104413263ouph_e
phage115113673__phage
phase104617213__phase
phat95837863__phat
phylae14458733phy_lae
pupae96515643pup_ae
raphe104916423raph_e
rhaphe1433423rhaph_e
scyphate1843273scyphate
shophar1555463shophar
spae65034323_sp_ae
sylvae12236863sylvae
syph125413273syph__
sypher14317083sypher
syphon1436853syphon
syphs13519453syph_s
thae76825563__thae
tophe106718973toph_e
typal105311153typ_al
type96223743typ__e
typhon1436673typhon
typhose1546693typhose
typhus14395713typhus
tythe115210453tyth_e

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716955.17321789.3
3Display Results95950.0303166.7
 (SQL Overall)178691955.57932029.2
 
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.