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

260 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
mythos1439846(None) 
mythoi14417131mythoi
myths135911601myth_s
bathos116215632bathos
ethos85514192_ethos
kythes16499132kythes
lithos94212552lithos
machos135217492machos
maths105624022math_s
matzos1749262matzos
method1239022method
methods1338882methods
meths105320232meth_s
metros84217802metros
mhos95517772m__hos
moths106021552moth_s
mottos84615242mottos
myth126715432myth__
mythic1637272mythic
mythy16568672myth_y
pathos115516692pathos
pothos114214692pothos
python1447142python
pythons1537362pythons
tythes12419702tythes
abmhos1334973abmhos
altho86312603altho_
altos55822953alt_os
anchos114214893anchos
author939763author
authors10311853authors
autos56523323aut_os
ayahs116813523ayah_s
bathes116524833bathes
baths105922923bath_s
benthos1238373benthos
beths105519223beth_s
bohos105618253_bohos
buteos84913413buteos
bytes105217493byt_es
cohos105921853_cohos
cyclos1338073cyclos
cyton101511463cyt_on
cytons111710183cytons
datos65222783dat_os
dattos74311903dattos
dittos74111973dittos
echos105216463_echos
ethnos947053_ethnos
eths76619523_eth_s
fathom1437473fathom
fathoms1537523fathoms
fatsos9389423fatsos
fynbos1433283fynbos
fyttes1236933fyttes
goths96513003goth_s
gyros95616483gy_ros
heths116317783heth_s
hos68364193___hos
hydros13279363hydros
hypos1312014743hy_pos
intros64215773intros
jatos125116823jat_os
kithes135016653kithes
kiths125814973kith_s
kotos95717703kot_os
kytes125012913kyt_es
kythe15509673kyth_e
kythed17407313kythed
lathes95127493lathes
lathis95516173lathis
laths86022403lath_s
lekythos1851663lekythos
lethes94818083lethes
litho86513783litho_
lithops12307253lithops
lotos54724633lot_os
lottos64613103lottos
lyches144213613lyches
lyttas985073lyttas
maches134827233maches
macho126120153macho_
machs125722563mach_s
macros104017013macros
mahoe10315573m_ahoe
mahoes11313103m_ahoes
makos116518363m_akos
malthas1237913malthas
mambos125414493mambos
mangos94319333mangos
manos74933623m_anos
mashes115030003mashes
matches143219783matches
maters85032393maters
mates75251363mat_es
mateys115610943mateys
math95437453math__
matins84527783matins
matres84522233matres
matron83918313matron
matrons93517633matrons
mats65460293mat__s
mattes85624533mattes
matts76829183mat_ts
matzas1749703matzas
matzo16312893matzo_
matzoh2035483matzoh
matzohs2134373matzohs
matzot17710983matzot
mayos105521933m_ayos
memos95719113m_emos
menthol1236723menthol
menthols1347033menthols
meshes115019443meshes
metals84520883metals
meteor84910073meteor
meteors94610013meteors
meters85625833meters
metes74736213met_es
meth95827843meth__
methoxy2243943methoxy
methyl1436403methyl
methyls1535453methyls
metis75025903met_is
metol75917813met_ol
metols84115773metols
metres85121563metres
metro74718803metro_
mezzos1635053mezzos
mho86624623m__ho_
miches134320733miches
micros104115363micros
mights123516253mights
mikvos1554023mikvos
milos75428013m_ilos
mimeos104511543mimeos
mirths114912993mirth_s
misos76523293m_isos
miters84328783miters
mites75141803mit_es
mither114218563mither
mithers123516733mithers
mitis75425993mit_is
mitres83922073mitres
mitts75523753mit_ts
mochas13310663mochas
mojos145314463m_ojos
mondos95217333mondos
mongos94318623mongos
monos75930863m_onos
months113812933month_s
moos66051303m__oos
morphos14159083morphos
morros83714673morros
mos57067123m___os
moshes115222873moshes
motels83616893motels
motes75944003mot_es
motets84216193motets
moth96731333moth__
mother113718643mother
mothers123717623mothers
mothy136214553moth_y
motifs1139673motifs
motion85217553motion
motions94215003motions
motmot10311073motmot
motmots1166133motmots
motor75317293mot_or
motors84616603motors
mots66853163mot__s
mottes85523693mottes
motto76119513motto_
mottoes93412193mottoes
motts76527003mot_ts
mouths115214533mouth_s
mozos165516333m_ozos
muches134718993muches
mucho125013443mucho_
mungos94311373mungos
mushes114124563mushes
musths11589483musth_s
mutches143314283mutches
mutes75033783mut_es
muton73817003mut_on
mutons84314363mutons
muts64839983mut__s
mutton8510453mutton
muttons949283muttons
mutts75120253mut_ts
myases113711553myases
myasis114010473myasis
mycs115314293my__cs
mylars114310443mylars
mynahs14416443mynahs
mynas105815233my_nas
myomas1338303myomas
myopes13419963myopes
myoses114013843myoses
myosis114012563myosis
myotics14257603myotics
myrrhs1443603myrrhs
myrtles1235733myrtles
mysids1246563mysids
mysost1138263my_sost
mystics14279103mystics
mythier15125183mythier
mythiest1636033mythiest
nachos115014183nachos
nitros64214123nitros
nymphos1744083nymphos
oaths86117313oath_s
ortho8312293ortho_
ottos54714323_ottos
paths105521383path_s
patios85221783patios
piths105817543pith_s
pottos84615873pottos
psychos1765263psychos
pyros105718293py_ros
ratios64922673ratios
ratos55528763rat_os
retros63820193retros
rhos76319063__rhos
rhythms1842553rhythms
rotos56027883rot_os
ruths85714643ruth_s
scythes15356523scythes
skyphos1963733skyphos
smiths114711023smith_s
soths86218633soth_s
synths12377883synth_s
syphon1436853syphon
syphons1537503syphons
syphs13519453syph_s
taos45541003__taos
teths85418513teth_s
this76027383__this
tho67433963__tho_
those85218143__those
thou76722213__thou
thous86017263__thous
thus76721473__thus
tithes94720213tithes
twos76718023__twos
typhon1436673typhon
typhons1537083typhons
typhose1546693typhose
typhous1566323typhous
typhus14395713typhus
typos106015813ty_pos
tyros85118593ty_ros
tythe115210453tyth_e
tythed13457503tythed
withes124620843withes
wyches17387913wyches
wytes114113433wyt_es
xystos16356913xystos
yahoo112911543_yahoo
yahoos12209243_yahoos

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.1401276364.3
2DLD Change Limit1127162605.76619548.4
3Display Results2602600.1561666.7
 (SQL Overall)1786912606.06229477.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.