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

289 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
myiases123549(None) 
myases113711551my_ases
myiasis1245481myiasis
aliases7914492aliases
amylases1346652amylases
biases84618432_biases
cycases1437532cycases
eyases94513682ey_ases
gyrases11368312gyrases
lyases95211872ly_ases
meioses9310832meioses
miasms1097382m_iasms
mioses84318852m_ioses
mises74740562m_i_ses
misses85130872m_isses
mutases92012042mutases
myasis114010462my_asis
mycoses1437722mycoses
mydriases1563082mydriases
myoses114013842my_oses
zymases21938332zymases
abases85720773_abases
abioses9311493abioses
amebiases1343723amebiases
amidases1136643amidases
amylase1237013amylase_
amyloses1347213amyloses
anises64826693ani_ses
anlases72514903anlases
apyrases1337243apyrases
arises65233803ari_ses
arrases71214543arrases
atlases72410643atlases
avgases11106313avgases
aviates10313063aviates
axises134413993axi_ses
baases85218013_baases
balases93815433balases
bases75644353__bases
biased94012223_biased
biasses94911653_biasses
birses84717733_birses
bises75435623_bi_ses
blisses94911513blisses
bolases93315003bolases
braises93818873braises
brises84927613bri_ses
brisses94314313brisses
bynames14256243bynames
bypass1345043bypas_s
bypasses1533833bypasses
camases114216343camases
capiases1239253capiases
cases75048383__cases
ceases84427073_ceases
chaises124317493chaises
chases115128233_chases
chiasms14357523chiasms
chiauses1336483chiauses
crases85532313_crases
creases94020963creases
crises84529433cri_ses
cuisses9319883cuisses
cyclases1537133cyclases
cyeses11510123cy_eses
daises74318983dai_ses
debases103814133debases
degases93413103degases
dieses75218693_dieses
disses75225963_disses
dynasts1155103dynasts
eases56041613__eases
ectases92911673ectases
egises7312493egi_ses
emphases1568353emphases
encases93116053encases
entases72816273entases
epitases1038933epitases
erases64425403_erases
eyass84410783ey_as_s
eyasses10388023eyasses
feases95422923_feases
fraises104215693fraises
frises94124273fri_ses
gases65633993__gases
greases84816713greases
grilses8319153grilses
guises74216313gui_ses
gyrase10508773gyrase_
gyrates113610263gyrates
hisses94719353_hisses
hoises94823673hoi_ses
hydrases15227643hydrases
hyraces1537913hyraces
hyraxes2045703hyraxes
ibises83610533ibi_ses
incases93615973incases
irises64221173iri_ses
judases1534443judases
kinases113511123kinases
kisses104217333_kisses
krises105016083kri_ses
kvases13467103_kvases
lases54944763__lases
leases65428113_leases
liaises7311053_liaises
lianes63819323_lianes
ligases82310703ligases
lipases9209483lipases
lyase85512413ly_ase_
lysates10317473lysates
lyses84518253ly__ses
mabes96331533m__abes
maces97139963m__aces
madames12310063madames
madrases112610003madrases
maes66948393m__a_es
mages85036023m__ages
mailes84329113mai_les
maists85817573mai_sts
maizes175115733mai_zes
makes115336853m__akes
malaises10312333malaises
malates93522603malates
males75049793m__ales
maltases1039693maltases
manages103418963manages
manes76648953m__anes
manses84225513m_anses
mares76457633m__ares
marses84827113m_arses
masas75630413m__asas
maser75029973m__aser
masers84623453m__asers
mashes115030003m__ashes
masks115320533m__asks
mass66044933m__as_s
masse75125293m__asse
masses85028713m_asses
masts77035763m__asts
mates75251363m__ates
mavises122812993mavises
maxes145629533m__axes
mazes165632173m__azes
measles92412753m_easles
mediates112814063mediates
megass9219443megas_s
megasse10266243megasse
megasses11307743megasses
meinies92516073meinies
meiosis939023meiosis
menaces112715523menaces
menages103615393menages
menses84222453m_enses
merises93421423merises
messes84924343m_esses
metages102714973metages
metates92720003metates
metisses1036833metisses
miaous8511693m_iaous
miaows1145473m_iaows
miasm91211093m_ias_m
miasma1097563m_iasma
miasmas1167743m_iasmas
miauls8178713m_iauls
miches134320733m_iches
midges103516473m_idges
midsts95510053m_idsts
mikes115129893m_i_kes
milages103114403milages
miles74645073m_i_les
milles84526563m_illes
mimes95732023m_i_mes
mimeses1139073mimeses
minces104420803m_inces
mines75651953m_i_nes
minkes124618783m_inkes
minuses93512703minuses
minxes154612983m_inxes
miosis83615163m_iosis
mirages102213533mirages
mires75640883m_i_res
misbiases1346253misbiases
mise66043573m_i_se_
miseases102614343miseases
miser75430403m_i_ser
misers85025703m_i_sers
misos76523293m_i_sos
miss65339413m_i_s_s
missed94423603m_issed
missel85216523m_issel
missels94614813m_issels
misset85028153m_isset
missets94516573m_issets
missies93423983m_issies
missis84417503m_issis
missus85312293m_issus
mists76633903m_i_sts
misuses93216023misuses
mites75141803m_i_tes
mitises9315543mitises
mitoses9312183mitoses
mitres83922073m_itres
mixes147224403m_i_xes
moires8915633moi_res
molasses1037233molasses
momuses1159263momuses
monades103713823monades
morales93619403morales
morass84614493moras_s
morasses1038903morasses
mosses85527683m_osses
mouses85531423m_ouses
mousses94012703mousses
mucuses11148513mucuses
muriates10312083muriates
muses75134303m__uses
musses84624783m_usses
mutase82811983mutase_
mutates92215793mutates
myceles1435213myceles
mycosis1437753mycosis
mydriasis1552623mydriasis
mylars114310443myla_rs
mynahs14416443myna_hs
mynas105815233myna__s
myopes13419963my_opes
myopies14309713myopies
myosis114012553my_osis
myriads1334343myria_ds
myrtles1235733myrtles
mysosts1234543mysosts
naiades838213naiades
noises65021853noi_ses
oases55330983__oases
opiates9312143opiates
oxidases1643883oxidases
oyesses1037333oyesses
pases75346503__pases
peases85229473_peases
peises84125043pei_ses
phases114618403_phases
phrases12711463phrases
pisses84525083_pisses
pleases94515483pleases
plisses94411773plisses
poises84226543poi_ses
praises94121103praises
prases84429023_prases
prises84133173pri_ses
prisses94816713prisses
pyoses114314303py_oses
raises64826543rai_ses
rases55447213__rases
rinses64720383_rinses
rises55244043_ri_ses
seises64026713sei_ses
shikses14116573shikses
sises55233833_si_ses
sisses64520603_sisses
stases64225563_stases
swisses10417143swisses
sycoses1249133sycoses
synapses1344713synapses
syngases1245073syngases
teases65426273_teases
teniases838623teniases
texases1437573texases
triages82613793triages
trioses75015653trioses
ukases10358063_ukases
uncases93516553uncases
uneases73316263uneases
upases84112903_upases
urases63723563_urases
ureases74416723ureases
vases84626263__vases
vises84427773_vi_ses
wises85633193_wi_ses
wisses94619603_wisses
xyloses1746843xyloses
yeasts96413053_yeasts
yeses85119323_y_eses
yesses93615813_yesses
yikes125117753_yi_kes
yipes106017843_yi_pes
zygoses20436783zygoses
zymase201997483zymase_
zymoses21608693zymoses

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.1561145455.1
2DLD Change Limit1340272896.37321030.4
3Display Results2892890.1102627.3
 (SQL Overall)1786912896.63926915.3
 
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.