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 “myriads” 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
myriads133435(None) 
myriad1235911myriad_
byroads1335292byroads
murids93212192muri_ds
myriapods1751542myriapods
myricas1436752myricas
mysids1246562mysi_ds
triads74513532_triads
aerials74017553aerials
agrias74315393agria_s
arias55438023_aria_s
brads85528293_br_ads
braids95015693_braids
breads95419203_breads
briards10398553_briards
briars84814823_briars
broads94515153_broads
burials93612083burials
byroad1236623byroad_
cerias83321983ceria_s
cycads14476213cy_cads
cyprians1544213cyprians
dreads84115023_dreads
dryads11436623_dryads
durians839573durians
dyads10549973dy__ads
eyras84715923eyr_a_s
eyries93816813eyri_es
farads104713273far_ads
ferias95020393feria_s
friars93812093_friars
grads75625753_gr_ads
grids75321393_gri_ds
grinds84511843_grinds
hybrids16236023hybri_ds
hydrids15267233hydri_ds
hyoids1377673hyoi_ds
iliads7448673_iliads
inroads837043inroads
irids66417773_iri_ds
jerids142810943jeri_ds
kyries133411373kyri_es
lariats7615053lariats
lyrics11357943lyri_cs
lyrisms1235653lyrisms
lyrists1036963lyrists
mads76845373m___ads
maenads1037373maenads
mafias113913573mafia_s
magians10310753magians
maids86327143m_ai_ds
maniacs114313063maniacs
manias84029033mania_s
maras75443293mar_a_s
marauds1037553marauds
margays1337493margays
maria75032883maria__
marinade11259383marinade
marinades12268973marinades
marinas93519393marinas
marines93928013marines
markas124717003marka_s
marrams11310123marrams
marrieds11288073marrieds
martians103111613martians
maybirds1643323maybirds
mbiras1077153mbira_s
meads85425323m__eads
mediad104313713mediad_
medials103914733medials
medians103214213medians
medias93620783media_s
menads95514383m_enads
menials94015683menials
merinos9311983merinos
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
mermaids1355753mermaids
mids76541793m__i_ds
milds86422053m__ilds
minds85427123m__inds
mirins83918903miri_ns
mirzas1738183mirza_s
misreads11268923misreads
monads94515303m_onads
morals85324633mor_als
moras76438783mor_a_s
morass84614503mor_ass
morays114613883mor_ays
morgans10310123morgans
morions94014643morions
mortals93914003mortals
mortars93411523mortars
murals84016763mur_als
muras75329583mur_a_s
muriate9313363muriate
muriates10312083muriates
murices112612283murices
murid84520583muri_d_
murines93718223murines
murras84916013murra_s
mydriases1563083mydriases
mydriasis1552623mydriasis
myiases1235493my_iases
myiasis1245493my_iasis
mylars114310443my_lars
mynahs14416443my_nahs
mynas105815233my_na_s
myoid11512993myoi_d_
myomas1338303myoma_s
myopias14308153myopia_s
myriapod1641473myriapod
myrica1336833myri_ca
myriopods1751823myriopods
myrrhs1443603myr_rhs
myrtles1235733myrtles
mysid11610693mysi_d_
naiads739013_naiads
norias65518203noria_s
oreads73915773_oreads
pariahs123812343pariahs
parians93519733parians
periods10312243periods
pleiads1045223pleiads
pyrans11411063pyr_ans
pyrites12812203pyrites
pyurias1236713pyuria_s
rads56046603__r_ads
raids65827513__raids
reads64835273__reads
rereads81512293rereads
rials55026673__rials
rias45540593__ria_s
rids56539553__ri_ds
rinds64826143__rinds
roads66523623__roads
serials73919743serials
spreads1039763spreads
threads11419953threads
treads74817923_treads
triacs83913223_triacs
triad65217723_triad_
trials64319883_trials
urials64415193_urials
varias95019903varia_s
yairds10448023_yairds
yids85224963_y_i_ds
yirds96612513_y_irds

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271495.65623696.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.09529317.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.