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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
hyphal173641(None) 
hypha1637381hypha_
hyphae1746431hyphae
hyetal1236542hyetal
hymnal1434912hymnal
hyphen1736392hyphen
nymphal1744032nymphal
typal105311152typ_al
alpha1049653alpha_
alphas1139513alphas
alphyl1484083alphyl
appal95315223_appal
appeal103911613appeal
asphalt1248083asphalt
byplay1634193byplay
byssal1134993byssal
clypeal1443513clypeal
copal95621783cop_al
cryptal1445683cryptal
cymbal15236913cymbal
cypher16306593cypher
dhal86719283__dhal
epha9310053_epha_
ephah1337063_ephah
ephas10311543_ephas
espial839543espial
gyral94412783gy_ral
hadal95518123h_adal
haemal113811643haemal
haha107821063h_aha_
hahas117118443h_ahas
halal85623593h_alal
hallal94415563hallal
hamal104623113h_amal
hammal134512063hammal
hapax1739323hap_ax
hartal9415473hartal
heal75645693h__eal
heehaw1543933heehaw
hemal104419803h_emal
hepcat13611823hepcat
heptad1237273heptad
herbal112513493herbal
hiatal9310203hiatal
hiemal11339503hiemal
hophead16337923hophead
horal86328683h_oral
huppah1644183huppah
hydra12249223hydra_
hydrae13258573hydrae
hydras13239313hydras
hyena11810253hyena_
hyenas1288953hyenas
hyla106716513hy_la_
hylas114815903hy_las
hymenal1545193hymenal
hymnals1543533hymnals
hyoidal1444803hyoidal
hyp117822463hyp___
hype125519813hyp__e
hyped145313333hyp_ed
hyper135213903hyp_er
hypers144811913hypers
hypes135818673hyp_es
hypethral2053093hypethral
hyphens1836043hyphens
hyping15408483hyping
hypnic1637263hypnic
hypo127516353hyp__o
hypoed1547923hypoed
hypogeal1744743hypogeal
hypos1312014743hyp_os
hyps125418413hyp__s
hyrax1838033hy_rax
keypal1534893keyp_al
lethal939803lethal
mughal1236273mughal
nopal75517103nop_al
nuchal11218873nuchal
nympha1643573nympha_
nymphae1743833nymphae
omphali1444513omphali
opal66923523_op_al
orphan1137733orphan
oxyphil2242373oxyphil
pal56761673__p_al
papal95820673pap_al
peal68648103__peal
phat95837863__phat
phial10313203__phial
pial65636703__pial
pipal95118353pip_al
pupal97616873pup_al
raphae114311733raphae
repeal84718283repeal
rhaphae1543193rhaphae
sepal77723003sep_al
septal84513383septal
shophar1555463shophar
syph125413273syph__
sypher14317083sypher
syphon1436853syphon
syphs13519453syph_s
tepal76319583tep_al
tymbal13236823tymbal
typhon1436673typhon
typhus14395713typhus
typical1436343typical
withal1238933withal

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.393454684.5
2DLD Change Limit1127161095.18621734.7
3Display Results1091090.0462369.6
 (SQL Overall)1786911095.62531767.3
 
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.