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

149 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
hymnal143491(None) 
hymenal1545181hymenal
hymnals1543521hymnals
cymbal15236912cymbal
hamal104623112ham_al
hammal134512062hammal
hemal104419802hem_al
hyena11810252hyena_
hyenas1288952hyenas
hyetal1236542hyetal
hymeneal1643472hymeneal
hymenial1645292hymenial
hymn12311312hymn__
hymnary1843032hymnary
hymned1535322hymned
hymns1337522hymn_s
hyphal1736412hyphal
tymbal13236822tymbal
agonal7410053agonal
ammonal1137023ammonal
anal48037523__anal
annal56520763_annal
atonal6514023atonal
axonal1347653axonal
azonal1568273azonal
banal75925993_banal
binal75323823_binal
byssal1134993byssal
canal75428043_canal
carnal83919213carnal
clinal8311553clinal
clonal8310913clonal
comal95125133com_al
cyma116715843cym_a_
cymae126713013cym_ae
cymar125711263cym_ar
cymas126417883cym_as
cymbals16236143cymbals
cymol1287623cym_ol
domal85619203dom_al
dynel9569853dy_nel
faunal94711593faunal
final83922033_final
geminal10109913geminal
gimbal11228813gimbal
gimmal11247513gimmal
gymnast1344163gymnast
gyral94412783gy_ral
hadal95518123h_adal
haemal113811643haemal
halal85623593h_alal
hallal94415563hallal
hamals114816823ham_als
hamaul114210873hamaul
hammals14409223hammals
hammam12419333hammam
hamza19139773hamza_
hamzah23135563hamzah
hamzas20119013hamzas
hartal9415473hartal
heal75645693h__eal
hematal1238953hematal
henna84414043henna_
hennas94211803hennas
herbal112513493herbal
hernial10310433hernial
hiatal9310203hiatal
hiemal11339503hiemal
hobnail1243973hobnail
honan85319773h_onan
horal86328683h_oral
hormonal1346633hormonal
hryvna1541573hryvna_
hryvnas1641493hryvnas
human102716033hum_an
humane112812173humane
humanly1545683humanly
humans112312433humans
humeral1238563humeral
humoral1237973humoral
hyaena1235363hyaena_
hyaenas1334983hyaenas
hydra12249223hydra_
hydrae13258573hydrae
hydras13239313hydras
hyenic1438723hyenic
hying126514743hyin_g
hyla106716513hy_la_
hylas114815903hy_las
hymen13311043hym_en
hymeneals1742533hymeneals
hymenia1546393hymenia
hymens1437993hymens
hymning1635183hymning
hymnist1546633hymnist
hymnody1942363hymnody
hyoidal1444803hyoidal
hypha1637383hypha_
hyphae1746433hyphae
hypnic1637263hypnic
hyrax1838033hy_rax
jumbal1758463jumbal
laminal94113633laminal
lienal63912783lienal
liminal93810673liminal
lumenal9307273lumenal
luminal93711003luminal
mammal95112753mammal
meal65643173__meal
myna95815303my_na_
mynah13569563my_nah
mynas105815233my_nas
nominal92712373nominal
nounal639813nounal
nymphal1744033nymphal
penal75228373_penal
phonal11310383phonal
pinnal84814273pinnal
ramal74622243ram_al
regnal74812933regnal
renal55929503_renal
rhinal9510193rhinal
ruminal9289993ruminal
sambal105215183sambal
seminal91213413seminal
signal73711483signal
simnel857023simnel
spinal84915313spinal
symbol1336083symbol
tamal73522623tam_al
tarnal63716503tarnal
thenal92712423thenal
thymol1434463thym_ol
timbal102510753timbal
tombal102311023tombal
tonal53724303_tonal
trinal6516963trinal
tymbals14265723tymbals
tympan13257013tympan
tympanal15243283tympanal
typal105311153ty_pal
urinal6614123urinal
veinal93812963veinal
venal85523213_venal
vernal93514213vernal
viminal12288823viminal
vinal85725813_vinal
zonal145116853_zonal
zoonal1558083zoonal

Search took 5 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.403443402.0
2DLD Change Limit1127161494.40625582.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911494.85536805.6
 
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.