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

221 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
myrica133683(None) 
myricas1436751myricas
erica7316542_erica
lorica8310442lorica
lyric104512722lyric_
lyrical1236492lyrical
lyrics11357942lyrics
maraca10314152maraca
maria75032882mari_a
marina84623412marina
mica86428252m__ica
modica11310062modica
myriad1235912myriad
pyric123815072pyric_
agria65517143agri_a
amrita8411133amrita
amylic13108713amylic_
areca75618633_areca
aria46245423_ari_a
arnica8310443arnica
arriba867683arriba
atria56022343atri_a
auric74521733auric_
barca91319433bar_ca
baric96125693baric_
boric98024223boric_
brick134618153_brick
carina84325323carina
carioca1139683carioca
ceria75125353ceri_a
ceric94023093ceric_
chica125818263_chica
circa9311403cir_ca
coria75828323cori_a
crick135118753_crick
curia74523773curi_a
cynic124712423cynic_
cynical1437873cynical
cynics13377363cynics
daric85623113daric_
darics94314113darics
emerita938713emerita
enrich1138943enrich
ericas8315463_ericas
eyra76217553eyr__a
eyrie88117833eyri_e
eyries93816813eyries
eyrir8359653eyri_r
farina94618233farina
feria85922713feri_a
formica1436443formica
gyri85415153gyri__
gyring113910363gyring
hayrick1944183hayrick
hydria13227903hydri_a
hydric15227953hydric_
jarina134014063jarina
kyrie123712903kyri_e
kyries133411373kyries
lexica1536103lexica
loricae938253loricae
lyricon1243713lyricon
lyrism1137473lyrism
lyrist9312293lyrist
lytic104513033lytic_
mafia104418033mafi_a
mafic125615463mafic_
magic105818653magic_
magical1239783magical
magics115311613magics
malic94525663malic_
malice104818483malice
mania75634153mani_a
maniac103917973maniac
manic94629443manic_
manics103919933manics
manila84518303manila
manioca11358943manioca
mara67444573mar__a
maracas11313773maracas
marasca1136823marasca
marc87034633mar_c_
march125622893mar_ch
marcs95726623mar_cs
marimba1354983marimba
marinas93519383marinas
marine84230403marine
marish114319053marish
marital92314183marital
marka114620793mar_ka
markka11416593markka
maxima17568633maxima
mbira977973m_bira
mecca1139933m_ecca
media84721713medi_a
medic104619653medic_
medical12312513medical
medick154010133medick
medico113711163medico
medics114115353medics
medina94114093medina
melic94722333melic_
merc87225623mer_c_
merch125417963mer_ch
mercs96020453mer_cs
mercy125916183mer_cy
merino8315093merino
merit7339183meri_t
merits8320873merits
mesic93617863mesic_
metical11315363metical
metric10314673metric_
metrical12311593metrical
metrics11312363metrics
mic77647643m__ic_
micas96823053m__icas
mice87442233m__ice
mick126333433m__ick
micra96214973m__icra
mics87435153m__ics
milia72719573mili_a
mimic111414323mimic_
mimical1339233mimical
mimics1289363mimics
mina65136923m__ina
minicab13177163minicab
minicam131110053minicam
minicar11109313minicar
minima105512653minima
miri66730373miri__
mirier83918363mirier
mirin75023153miri_n
miring93723803miring
mirins83918903mirins
mirza16410443mir_za
moira71012023m_oira
mora66641273mor__a
morion86217733morion
mortice11711493mortice
morula8710473morula
mura65633293mur__a
muricate12311113muricate
murices112612283murices
murid84520583muri_d
murids93212193murids
murine84220023murine
muring95120373muring
murra74519083mur_ra
murrha11366453murrha
musca9311763m_usca
music94316403music_
musical1139553musical
musick14408703musick
musics103911783musics
myc106519503my__c_
mycs115314293my__cs
myna95815303my__na
myoid11512993myoi_d
myoma1239273my_oma
myopia13318443myopia
myopic15308463myopic_
myotic133112313myotic_
myotics14257603myotics
myriads1334353myriads
myrrh1337093myr_rh
myrrhic1743763myrrhic_
myrrhs1443603myrrhs
myrtle1135733myrtle
mysid11610693mysi_d
mysids1246563mysids
mystic132711643mystic_
mystical1546933mystical
mystics14279103mystics
mythic1637273mythic_
mythical1845033mythical
myxoma2043943myxoma
naric76824173naric_
noria55722183nori_a
orca65522773_or_ca
orrice81410163orrice
paprica1337003paprica
pica85831493__pica
plica9613373_plica
price93725413_price
prick134317503_prick
pricy124814563_pricy
prima95019343_prima
pyic116915823py_ic_
pyrite11913313pyrite
pyrola1139003pyrola
pyuria1136953pyuri_a
ria36745503__ri_a
rice64942913__rice
rich97025543__rich
rick107334653__rick
silica8311243silica
spica94717943_spica
stria55723213stri_a
strick124813203strick
strict84821043strict
syringa11366353syringa
syrinx1637143syrinx
thrice114311573thrice
toric76529313toric_
torics85118353torics
triac74116373_triac
trice75127493_trice
trick115420693_trick
tunica8379813tunica
typic124511963typic_
typical1436343typical
tyring104613023tyring
uric63624933_uric_
varia85824203vari_a
vesica11157913vesica
vomica1336383vomica
wrick144013393_wrick
xeric144315663xeric_
yuca95716723_y_uca
yucca12467443_yucca
zariba1736983zariba

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.1401276364.3
2DLD Change Limit1127162214.75023729.7
3Display Results2212210.0633507.9
 (SQL Overall)1786912214.95336077.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.