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

183 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
pathoses1341277(None) 
bathoses13310461bathoses
cathodes1439392cathodes
cathouses1439432cathouses
ethoses10311762_ethoses
kathodes1646182kathodes
orthoses11311142orthoses
papooses1248052papooses
pathless13138042pathless
pathogen1446462pathogen
pathogens1545712pathogens
pathos115516692patho__s
phthises1645722phthises
potholes13312932potholes
pothouses1449042pothouses
ptoses83514672p_t_oses
ratholes11312412ratholes
spathose1345632spathose_
abioses9311493_abioses
aldoses8311203_aldoses
antheses11311473antheses
apathies1339013apath_ies
apheses12610703_apheses
apodoses1136653apodoses
apotheoses1543873apotheoses
apposes11511473_apposes
arkoses113910833_arkoses
arthroses1248733arthroses
athetoses1244973_athetoses
atlases72410643_atlases
atones65225773_at_ones
baghouses1545463baghouses
bathes116524833bath__es
bathhouses1844193bathhouses
bathless13127383bathless
bathos116215633batho__s
bathrobes1644393bathrobes
benthoses1446693benthoses
boathouses1545923boathouses
cabooses1237863cabooses
calloses10313393calloses
carthorses1546363carthorses
caseoses1039293caseoses
catharses1446413catharses
cathexes2036273cathexes
cathode1338993cathode_
cathouse1338863cathouse_
choses115825133__choses
diatheses1345893diatheses
empathises17104063empathises
enthuses1138253enthuses
estheses1137783estheses
ethnoses1146083_ethnoses
fathomed1744733fathomed
fathomer1645293fathomer
fathomers1744953fathomers
fathoms1537523fatho_ms
fatsoes10379423fatso_es
gashouses1345763gashouses
gatehouses1445263gatehouses
haploses1338853haploses
hatboxes2055003hatboxes
hoses85443183___hoses
hothouses1547763hothouses
katharses1643873katharses
kathode1545733kathode_
ketoses114912873ket_oses
kyphoses2045283kyphoses
lactoses1039833lactoses
lathes95127503lath__es
lotoses73713653lot_oses
madhouses1545743madhouses
mahoes11313103ma_ho_es
maltoses1039863maltoses
manholes13311183manholes
mannoses1039083mannoses
mitoses9312183mit_oses
narcoses103910553narcoses
nathless11127023nathless
nuthouses1246343nuthouses
oasthouses1344973oasthouses
orthosis1148203orthosis
osteoses839033osteoses
ostoses71213553ost_oses
outhouses12310663outhouses
pachisis15268823pachisis
packhorses2143363packhorses
padrones112711043padrones
pandores11312453pandores
pantihose1444793pantihose_
pantyhose1742873pantyhose_
papoose1147513papoose_
pappooses1243993pappooses
pappose1047413pappose_
paradoses122510263paradoses
parcloses1347963parcloses
pareses94718883pa_reses
parises94827193pa_rises
paroles95025893pa_roles
parses85534703pa__rses
parvises133911923parvises
pases75346503pa___ses
pashes115828393pash__es
passes86030473pa__sses
passuses1036773passuses
pastises103616053pastises
patches143320383pat_ches
pates76047893pat___es
pathogene1545193pathogene
pathogenes1645953pathogenes
pathogeny1843743pathogeny
paths105521383path___s
pathways1944273pathways
patines95225773pat_ines
patios85221783patio__s
patness92912283patnes_s
patnesses111611793patnesses
patois84319363pat_o_is
patooties1147183patooties
patrols93513513patro_ls
patroness1137493patroness
patronises1298453patronises
patrons93818103patro_ns
patroons102710603patroons
patsies93919483pat_sies
patties93425143pat_ties
pauses84621473pa__uses
pavises125315493pa_vises
pavisses13397103pavisses
penthouses1546623penthouses
pentoses10312893pentoses
peploses1269473peploses
pestholes1448233pestholes
pesthouses1546253pesthouses
petasoses1145443petasoses
petioles10311643petioles
pharoses13310323pharoses
phases114618403p__hases
phimoses1537213phimoses
phones114121213p__hones
phthisis1654443phthisis
physes14399783p__hyses
pieholes13168913pieholes
pinholes131810663pinholes
pishoges1446953pishoges
pithless13117023pithless
playhouses1843873playhouses
portholes14410373portholes
poses74642763p___oses
postholes14410453postholes
postposes1348193postposes
pothole12312173pothole_
potholed1448393potholed
pothooks1746053pothooks
pothos114214693potho__s
pothouse1348703pothouse_
proposes122515973proposes
proses84733473p__roses
proteoses112211013proteoses
protheses1449073protheses
psiloses1036443psiloses
psychoses1946683psychoses
ptosis83611823p_t_osis
purposes1237823purposes
pycnoses1554973pycnoses
pyknoses1783573pyknoses
pyoses114314303p__yoses
pythoness1743733pythoness
pythons1537363pytho_ns
rachises131412413rachises
rathole10312053rathole_
saroses73619333sa_roses
sawhorses1543753sawhorses
spathes125116533spath__es
tapholes1339623tapholes
taphouses1446553taphouses
theses96517973__theses
tholes94919783__tholes
those85218143__those_
vamooses1345523vamooses
vamoses1239153va_moses
warhorses1545573warhorses
xanthones1957023xanthones

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621838.20317818.1
3Display Results1831830.0632904.8
 (SQL Overall)1786911838.68620572.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.