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

246 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
myriad123591(None) 
myriads1334351myriads
byroad1236622byroad
maria75032882maria_
mediad104313712mediad
murid84520582muri_d
myoid11512992myoi_d
myriapod1641472myriapod
myrica1336832myrica
myricas1436752myricas
mysid11610692mysi_d
triad65217722_triad
abroad9310943abroad
acrid86920103acri_d
aerial64625713aerial
aeried74221863aeried
afraid1049723afraid
agria65517143agria_
agrias74315393agrias
aria46245423_aria_
arias55438023_arias
arid57642713_ari_d
atria56022343atria_
atrial65418943atrial
brad75234343_br_ad
braid85822263_braid
bread85523113_bread
briar75718153_briar
briard94311293_briard
broad84817693_broad
burial84117623burial
buried94822373buried
byrled12437173byrled
byroads1335293byroads
caried94528693caried
ceria75125353ceria_
cerias83321983cerias
coria75828323coria_
cried84624283_cried
curia74523773curia_
curiae84518373curiae
curial84019153curial
cycad13507273cy_cad
cyprian1445343cyprian
dorsad8408973dorsad
dread74419023_dread
dried75321383_dried
dryad10477583_dryad
durian7312003durian
dyad96415453dy__ad
eyra76217553eyr_a_
eyras84715923eyr_as
eyrie88117833eyri_e
eyries93816813eyries
eyrir8359653eyri_r
farad95720673far_ad
feria85922713feria_
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
forbad122710503forbad
friar85414273_friar
fried95322913_fried
grad66829863_gr_ad
grid65829613_gri_d
grind75917563_grind
gyral94412783gyr_al
gyred105114093gyr_ed
gyri85415153gyri__
gyring113910363gyring
hybrid15237813hybri_d
hydria13227903hydria_
hydriae14246903hydriae
hydrid14248973hydri_d
hyoid12612443hyoi_d
hyrax1838033hyr_ax
iliad64613463_iliad
inroad737933inroad
irid55927173_iri_d
jerid132316423jeri_d
juried144212443juried
kyrie123712903kyri_e
kyries133411373kyries
lariat6629043lariat
lurid64618973luri_d
lyric104512723lyri_c
lyrical1236493lyrical
lyrics11357943lyrics
lyrism1137473lyrism
lyrist9312293lyrist
mad68958713m___ad
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
maid75537663m_ai_d
mania75634153mania_
maniac103917973maniac
manias84029033manias
mara67444573mar_a_
maras75443293mar_as
maraud938943maraud
margay12310593margay
marina84623413marina
marinade11259383marinade
marinas93519393marinas
marine84230403marine
marish114319053marish
marital92314183marital
marka114620793marka_
markas124717003markas
marked133921623marked
marled95523163marled
marram10313883marram
marred95421043marred
married104715303married
marted94425213marted
martial92415413martial
martian93514683martian
maybird1543993maybird
mbira977973mbira_
mbiras1077153mbiras
mead75531603m__ead
media84721713media_
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
menad85918983m_enad
menial84223033menial
merged104214953merged
merino8315093merino
merit7339183meri_t
merited10313853merited
merits8320873merits
mermaid1297853mermaid
merman10513863merman
mesial84818083mesial
mesian84315503mesian
mid67354473m__i_d
mild75330853m__ild
milia72719573milia_
mind75434383m__ind
mired85729223mir_ed
miri66730373miri__
mirier83918363mirier
mirin75023153miri_n
miring93723803miring
mirins83918903mirins
mirza16410443mirza_
mirzas1738183mirzas
misread10339723misread
moira71012023moira_
moirai886913moirai
monad85519473m_onad
monied94319463monied
mora66641273mor_a_
morae75831193mor_ae
moral75533433mor_al
moras76438783mor_as
moray105423793mor_ay
morbid112511463morbid
morgan9311373morgan
morion86217733morion
mortal84616853mortal
mortar83812043mortar
mucid104115253muci_d
mura65633303mur_a_
mural75225113mur_al
muras75329583mur_as
mured85726703mur_ed
muriate9313363muriate
muriated1139793muriated
murids93212193murids
murine84220023murine
muring95120373muring
murra74519083murra_
murras84916013murras
mylar105311533my_lar
myna95815303my_na_
mynah13569563my_nah
mynas105815233my_nas
myoma1239273myoma_
myomas1338303myomas
myopia13318443myopia_
myopias14308153myopias
myriapods1751543myriapods
myriopod1641883myriopod
myrrh1337093myr_rh
myrrhs1443603myrrhs
myrtle1135733myrtle
mysids1246563mysids
myxoid1936883myxoid
naiad6313403_naiad
narial6317953narial
noria55722183noria_
norias65518203norias
orad56031693_or_ad
oread64619603_oread
pariah114320583pariah
parian83223963parian
period9314983period
pleiad947833pleiad
pried84426863_pried
pyoid11513763pyoi_d
pyran10514473pyr_an
pyric123815073pyri_c
pyrite11913313pyrite
pyuria1136953pyuria_
pyurias1236713pyurias
rad47662003__r_ad
raid55243073__raid
read55942533__read
reread71715433reread
ria36745503__ria_
rial45938093__rial
rias45540593__rias
rid46754633__ri_d
rind56535603__rind
road56332113__road
scried95817303scried
serial64625863serial
spread9312533spread
stria55723213stria_
striae65422273striae
syrinx1637143syrinx
thread105011093thread
trad55630913_tr_ad
tread64821703_tread
triac74116373_triac
triads74513533_triads
trial54926353_trial
tried65026913_tried
tyred95816433tyr_ed
tyring104613023tyring
unread73412673unread
urial54823023_urial
varia85824203varia_
varias95019903varias
varied104817863varied
virid94116043viri_d
wried95518563_wried
yaird96111913_yaird
yclad11246383_yclad
yid76640833_y_i_d
yird87018983_y_ird

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162465.75019602.8
3Display Results2462460.0803075.0
 (SQL Overall)1786912466.20328807.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.