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

142 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
bathoses1331046(None) 
pathoses13412771pathoses
baghouses1545462baghouses
bathes116524832bath__es
bathhouses1844192bathhouses
bathless13127382bathless
bathos116215632batho__s
bathrobes1644392bathrobes
benthoses1446692benthoses
boathouses1545922boathouses
cathodes1439392cathodes
cathouses1439432cathouses
ethoses10311762_ethoses
kathodes1646182kathodes
orthoses11311142orthoses
ratholes11312412ratholes
abatises10311013abat_ises
abattises1155083abattises
abioses9311493_abioses
aldoses8311203_aldoses
antheses11311473antheses
apheses12610703_apheses
apposes11511473_apposes
arkoses113910833_arkoses
arthroses1248733arthroses
athetoses1244973_athetoses
atlases72410643_atlases
atones65225773_at_ones
baases85218013ba__ases
baches135426943bach__es
backhoes1938543backho_es
backhouses2145743backhouses
badasses1136173badasses
bagasses1136313bagasses
baghouse1445213baghouse_
bakehouses19134453bakehouses
balases93815433ba_lases
bandores11311603bandores
banjoes16317313banjo_es
baptises1238923baptises
barhops14288113barho_ps
bases75644353ba___ses
bashes115631393bash__es
basses85428303ba__sses
batboys1465833batbo_ys
batches144019613bat_ches
bates75846343bat___es
batfishes1746583batfishes
batfowls1642773batfowls
bathe105822883bath__e_
bathed125518743bath__ed
bather115322513bath__er
bathers124720363bath_ers
bathhouse1744193bathhouse_
bathmats1545933bathmats
bathrobe1544413bathrobe_
bathrooms1644773bathrooms
baths105922923bath___s
bathtubs1541883bathtubs
batistes1039713batistes
batons85519423bat_o_ns
battles94517683bat_tles
battues94610193bat_tues
beadhouses1644293beadhouses
behoves15177353b_ehoves
bethorns1337323bethorns
betises94816123bet_ises
bigoses1039073b_igoses
boathooks1844173boathooks
boathouse1445943boathouse_
boltholes1445723boltholes
bothies12414783both_ies
broses86524403b__roses
bughouses1544743bughouses
cabooses1237863cabooses
calloses10313393calloses
carthorses1546363carthorses
caseoses1039293caseoses
catharses1446413catharses
cathexes2036273cathexes
cathode1338993cathode_
cathouse1338863cathouse_
choses115825133__choses
diatheses1345893diatheses
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
papooses1248053papooses
pathless13138043pathless
pathogen1446463pathogen
pathogens1545713pathogens
pathos115516693patho__s
phthises1645723phthises
potholes13312933potholes
pothouses1449043pothouses
ptoses83514673_pt_oses
rachises131412413rachises
rathole10312053rathole_
saroses73619333sa_roses
sawhorses1543753sawhorses
spathose1345633spathose_
tapholes1339623tapholes
taphouses1446553taphouses
theses96517973__theses
tholes94919783__tholes
those85218143__those_
vamooses1345523vamooses
vamoses1239153va_moses
warhorses1545573warhorses
xanthones1957023xanthones

Search took 8 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.423422437.4
2DLD Change Limit1461621426.61022112.3
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.09325192.6
 
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.