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

167 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
myricas143674(None) 
myrica1336821myrica_
ericas8315462_ericas
lyrical1236492lyrical
lyrics11357942lyric_s
maracas11313772maracas
marinas93519372marinas
micas96823052m__icas
murices112612282murices
myriad1235892myri_ad
myriads1334342myriads
agrias74315393agri_as
amritas939093amritas
arecas84817443_arecas
arias55438023_ari_as
arnicas939543arnicas
barcas101016603bar_cas
bricks144614623_bricks
carices114220953carices
carinas93622383carinas
cariocas1239663cariocas
caritas93316943caritas
cerias83321973ceri_as
chicas135916463_chicas
cricks144316053_cricks
cycas126513823cy__cas
cylices14359283cylices
cynical1437873cynical
cynics13377363cynic_s
darics94314113daric_s
emeritas1046433emeritas
erica7316543_erica_
eyras84715923eyr__as
eyries93816813eyri_es
farinas103215233farinas
ferias95020393feri_as
formicas1545993formicas
fracas11311993_fracas
hayricks2043763hayricks
hyraces1537913hyraces
jarinas143712183jarinas
kyries133411373kyri_es
lorica8310443lorica_
loricae938253loricae
lyric104512723lyric__
lyricise13889973lyricise
lyricism15919103lyricism
lyricist13718983lyricist
lyricon1243713lyricon
lyricons1343583lyricons
lyrisms1235653lyrisms
lyrists1036963lyrists
mafias113913573mafi_as
magical1239783magical
magics115311613magic_s
malices114316623malices
maniacs114313063maniacs
manias84029033mani_as
manics103919933manic_s
manilas93915873manilas
maniocas12298463maniocas
maraca10314153maraca_
maras75443283mar__as
marascas1247383marascas
marcs95726623mar_c_s
maria75032883mari_a_
marimbas1444363marimbas
marina84623413marina_
marines93928013marines
marital92314183marital
markas124717003mar_kas
markkas12356083markkas
matrices12312083matrices
mbiras1077143m_biras
meccas1239493m_eccas
medias93620783medi_as
medical12312513medical
medicals1349363medicals
medicks16368413medicks
medicos12339833medicos
medics114115353medic_s
medinas103411463medinas
merces105720743mer_ces
mercies113817563mercies
mercs96020453mer_c_s
merinos9311973merinos
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
meticais1248183meticais
metical11315363metical
meticals12310763meticals
metrical12311583metrical
metrics11312363metric_s
mica86428243m__ica_
micks135525373m__icks
mics87435143m__ic_s
mimical1339233mimical
mimics1289353mimic_s
minas75434113m__inas
minicab13177163minicab
minicabs14135063minicabs
minicam131110053minicam
minicams14126863minicams
minicar11109313minicar
minicars12118503minicars
mirins83918893miri_ns
mirzas1738173mir_zas
modica11310063modica_
moras76438763mor__as
morions94014633morions
mortices12711553mortices
morulas959703morulas
muras75329563mur__as
muricate12311113muricate
murids93212193muri_ds
murines93718223murines
murras84916003mur_ras
murrhas12286163murrhas
musical1139553musical
musicals1247093musicals
musicks15297053musicks
musics103911783music_s
mycs115314293my__c_s
mynas105815233my__nas
myomas1338293my_omas
myopias14308143myopias
myotics14257593myotic_s
myrrhs1443593myr_rhs
myrtles1235733myrtles
mysids1246563mysi_ds
mystical1546933mystical
mystics14279103mystic_s
mythical1845023mythical
myxomas2153903myxomas
norias65518183nori_as
orcas75918623_or_cas
orrices9129363orrices
papricas1447053papricas
picas94626523__picas
prices104524543_prices
pricks144414263_pricks
primas104418103_primas
pyric123815073pyric__
pyrites12812203pyrites
pyrolas1239863pyrolas
pyurias1236703pyuri_as
rias45540593__ri_as
rices75536153__rices
ricks115126133__ricks
silicas9310603silicas
spicas104715823_spicas
stricks134310693stricks
syringas12285953syringas
torics85118353toric_s
triacs83913223_triacs
trices84826333_trices
tricks125319013_tricks
typical1436343typical
varias95019903vari_as
varices123313573varices
veritas103012753veritas
wricks154610623_wricks
yoicks15375933_yoicks
yucas106013913_y_ucas
yuccas13426553_yuccas
zaribas1836043zaribas

Search took 9 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271678.37316007.0
3Display Results1671670.0632650.8
 (SQL Overall)1786911678.57620836.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.