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

195 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
potashes133783(None) 
pashes115828392p__ashes
plashes124417392p_lashes
poaches144416942po_aches
polishes13711782polishes
potables12179702potables
potages102416422pota_ges
potash1138272potash__
potatoes1039942potatoes
potiches1539202potiches
potlaches16115262potlaches
potsies93019482pot_sies
protases102115032protas_es
stashes103916172_stashes
abashes12510373_abashes
apostasies1245583apostasies
ashes86230613___ashes
attaches13137723attaches
bashes115631393__bashes
bolases93315003bolas_es
boshes114721883bo__shes
botanies10312853botanies
botches143716023bot_ches
brashes124518463_brashes
calashes13310533calashes
cashes114729883__cashes
clashes124017283_clashes
coaches144018693co_aches
cohoshes1635883cohoshes
coshes115022783co__shes
crashes124618403_crashes
dashes106124983__dashes
deashes113313903_deashes
detaches1439653detaches
dotages92311793dota_ges
ectases92911673ectas_es
emdashes14224303emdashes
encashes13227673encashes
endashes12217453endashes
entases72816273entas_es
epitases1038933epitas_es
fashes124524023__fashes
fetishes1437153fetishes
flashes133916103_flashes
gamashes1456943gamashes
gashes105725153__gashes
gnashes11419573_gnashes
goloshes1236253goloshes
gouaches1436193gouaches
goulashes1343713goulashes
hashes125024803__hashes
hogwashes1942463hogwashes
hotches153814363hot_ches
joshes165114853jo__shes
lashes94831003__lashes
lavashes1445573lavashes
leashes103514403_leashes
loaches123613983lo_aches
loathes103513243lo_athes
lotahs9479873lota_h_s
lotoses73713643lotos_es
lotuses74011253lotus_es
mashes115030003__mashes
molasses1037233molasses
monishes13311483monishes
morasses1038903morasses
moshes115222873mo__shes
mutases92012043mutas_es
noshes96618233no__shes
notables10178243notables
notaries8314933notaries
notates72817483nota_tes
notches123513653not_ches
oases55330983_o_as_es
oraches124216473_oraches
outwashes15116183outwashes
panaches15310283panaches
parishes13314753parishes
pases75346503p__as_es
pashas115117063p__ashas
pashed125923143p__ashed
passes86030473p__asses
pastes85233913p__astes
patches143320383pat_ches
patsies93919483pat_sies
peaches144120053p_eaches
peases85229473p_eas_es
pectases122411193pectas_es
perishes13313753perishes
petasos948603petas_os
petasoses1145443petasoses
petasus946363petas_us
petasuses1144373petasuses
phases114618403p_has_es
phrases12711463phras_es
pishes114722103p__ishes
pistaches1646673pistaches
pitches143617753pit_ches
plashed133712643p_lashed
plasher124215033p_lasher
plashers133813453p_lashers
pleaches153210433pleaches
pleases94515483pleas_es
plushes124313673p_lushes
poached154212403po_ached
poacher143912323po_acher
poachers152910763po_achers
poesies93217403po_esies
poetaster1145673poetaster
poetasters1245283poetasters
poetesses1137233poetesses
poetises10313953poetis_es
poises84226543po_is_es
polished1468433polished
polisher1388073polisher
polishers1477603polishers
pomaces132712123poma_ces
pomades123711733poma_des
pooches143214163po_oches
popsies112816463po_psies
porches143815673po_rches
portables1337873portables
portages112613223porta_ges
portances1349833portances
poses74642763po__s_es
posher115018163po__sher
poshest12312423po__shest
posies84431433po__sies
posses85128803po__sses
postages112815323posta_ges
posthastes1546273posthastes
postiches1648223postiches
potable112115363potable_
potage92715903pota_ge_
potassic1244923potassic
potences12710693potences
pother113818853pot__her
pothers123818623pot__hers
potholes13312933potholes
pothos114214693pot__hos
potiche1438043potiche_
potlache15114283potlache_
potlatches17113323potlatches
potlines10714213potlines
potpies113116173pot_pies
potsherd1434813pot_sherd
potsherds1544023pot_sherds
potshot1249733pot_shot
potshots1346283pot_shots
potsie83916033pot_sie_
pottages112910453pottages
potties93723543pot_ties
pottles93816983pot_tles
pouches144116743po_uches
poussies1038113poussies
prases84429023p_ras_es
preaches153214893preaches
pretastes11119423pretastes
prewashes1744753prewashes
protasis102411973protas_is
proteases112110833proteas_es
ptoses83514673p_tos_es
punishes1338113punishes
pushes114621663p__ushes
putsches1535313putsches
quashes192110973_quashes
rashes95330153__rashes
rehashes1436953rehashes
retastes82212903retastes
rewashes1447033rewashes
roaches123616213ro_aches
rotaries8315693rotaries
rotates72819773rota_tes
rotches123515703rot_ches
sashes94728483__sashes
slashes103619103_slashes
smashes123914613_smashes
snashes105214753_snashes
soutaches1446443soutaches
splashes1337503splashes
squashes20207803squashes
stases64225563_stas_es
stashed113812493_stashed
swashes134714403_swashes
taches114224173__taches
tasses64826763__tasses
tastes64126423__tastes
thrashes1487653thrashes
toshes94520103__toshes
trashes104119263_trashes
tushes94319473__tushes
unlashes11238043unlashes
votaries11312013votaries
washes124425493__washes
wooshes13169883wo_oshes

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.403443402.0
2DLD Change Limit1461621957.65619091.2
3Display Results1951950.0802437.5
 (SQL Overall)1786911958.13921954.9
 
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.