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

452 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
potash113827(None) 
botas75328782botas_
iotas54821112iotas_
jotas125717442jotas_
lotah85315852lota_h
lotahs9479872lotahs
lotas55926302lotas_
pash95638132p__ash
pitas77427672pitas_
plash104616562p_lash
poach124917862po_ach
polish114916722polish
popish133812112popish
posh95427322po__sh
potage92715902potage
potashes1337832potashes
potato8513432potato
potlach14106362potlach
pots66452362pot_s_
potsy105815612pot_sy
rotas54827722rotas_
stash84916972_stash
abash106016513_abash
antas55432033antas_
aortas65417783aortas_
apostasy1344073apostasy
ash67944603___ash
attach11118393attach
awash116613163_awash
bash915240163__bash
betas75528763betas_
biotas84313923biotas_
boas66150833bo_as_
boast75935703bo_ast
boats75635153boats_
bolas74733763bolas_
boras75938303boras_
bosh96328973bo__sh
bota66236503bota__
botany1139263botany
botch126717453bot_ch
both96533433bot__h
bots66453953bot_s_
botts75224863botts_
boyish142911233boyish
brash106221563_brash
calash11312433calash
cash96636283__cash
clash106219033_clash
coach125919453co_ach
coast75236273co_ast
coats75635003coats_
cocas95926573cocas_
codas84724243codas_
cohosh14517123cohosh
colas75436773colas_
coltish121310933coltish
comas95833003comas_
cosh96127623co__sh
cotan71521783cota_n
cotans81317923cotans
cotes76347843cotes_
cots68054843cot_s_
cottas84615573cottas_
coyish143710393coyish
crash109120013_crash
dash87031633__dash
deash95617243_deash
detach12310413detach
ditas65923673ditas_
doats65224883doats_
doltish11118733doltish
donas65926473donas_
dopas85019063dopas_
dotage82711613dotage
dotal64919623dota_l
dotard839053dotard
dotes65836693dotes_
doth86225713dot__h
dots55647663dot_s_
dovish1338103dovish
emdash12244113emdash
encash11276943encash
endash10297123endash
epitaph1444133epitaph
etas46432273_etas_
fash107232293__fash
fetas85624403fetas_
fetish12310373fetish
flash115716213_flash
flotas94013003flotas_
gash86833023__gash
getas65421483getas_
gnash9449833_gnash
goas55239943go_as_
goatish1139563goatish
goats65527303goats_
golosh1036463golosh
gosh86123423go__sh
goth86825083got__h
goths96513003goths_
goulash1164273goulash
goyish13379013goyish
hash106936503__hash
hogwash1742713hogwash
horah117922053hora_h
horahs126313873horahs
horas86333103horas_
hostas94515823hostas_
hotch136214733hot_ch
hots78349333hot_s_
hottish13117903hottish
hoyas115016163hoyas_
iota45127833iota__
isotach1244953isotach
josh145117613jo__sh
jota116423623jota__
jots116336143jot_s_
katas95922093katas_
koas85635093ko_as_
kolas94822233kolas_
koras95927113koras_
kotos95717703kotos_
lash76539653__lash
latish92416173latish
lavash12597373lavash
leash85519213_leash
litas54923773litas_
loach105116363lo_ach
loath84918603lo_ath
lota47233503lota__
loth76132133lot__h
lotos54724633lotos_
lots47652093lot_s_
lotus55718063lotus_
loutish1039963loutish
lowish12310533lowish
mash96039403__mash
matsah1138233matsah
moas65545343mo_as_
moats75827643moats_
modish123813543modish
molas75132093molas_
monas74732153monas_
monish114217593monish
mopish134311593mopish
moras76438783moras_
morass84614503morass
mosh95227603mo__sh
motes75944003motes_
moth96731333mot__h
moths106021553moths_
mots66853163mot_s_
motts76527003motts_
moxas145014393moxas_
mutase82811993mutase
nomas74726413nomas_
nonas55126653nonas_
noncash1245163noncash
nosh76223543no__sh
nota46830773nota__
notal55221353nota_l
notary92310713notary
notate63217863notate
notch105613323not_ch
notes55034583notes_
novas85215363novas_
oast47156323_o_ast
oath76132153_o_ath
oaths86117313_oaths
oats46554213_oats_
obas65730933_obas_
ocas66729633_ocas_
odah87018933_oda_h
odahs95610083_odahs
odas57230263_odas_
okas85225393_okas_
omasa749483_omasa
oots46446443oot_s_
opah96218403_opa_h
opahs105411983_opahs
opts68124743opt_s_
orach105219233_orach
outask1039103outask
outwash13187613outwash
pacas96029403pacas_
pah88853593p__a_h
palish114718273palish
papas94927493papas_
paraph13311263paraph
paras76143043paras_
parish115022353parish
pas58775743p__as_
pase65346863p__ase
pasha105417183p__asha
pass65239953p__ass
past65959013p__ast
pastas85422873pastas_
pataca10311193pataca
patch125221223pat_ch
pates76047893pates_
path99134913p__ath
paths105521383paths_
pats66460853pat_s_
patsy105717203pat_sy
peach125422493p_each
peas65755063p_eas_
pease75231113p_ease
peats76140193peats_
pectase112410363pectase
pelotas9410723pelotas_
peltast9310513peltast
perish114619063perish
petal76526893peta_l
petals84719813petals
petard95013803petard
petasos948603petasos
petasus946363petasus
pets66248333pet_s_
petsai838083petsai
pettish1238283pettish
phase104617213p_hase
photos113316643photos_
phots105418503phot_s_
phrase11109903phrase
pias66542553p_ias_
picas94626523picas_
pietas84516503pietas_
pikas114218093pikas_
pimas94725103pimas_
pinas75434453pinas_
pintas85021393pintas_
pish96127913p__ish
pita65436433pita__
pitaya1186603pitaya
pitch125018413pit_ch
pith95432693pit__h
piths105817543piths_
pits66348743pit_s_
pitsaw1135613pitsaw
pittas86014523pittas_
plashy14448873p_lashy
plasm94114633p_lasm
plats75531373plats_
pleach134211243pleach
pleas75627033pleas_
please84315733please
plots75025673plot_s_
plush105614713p_lush
poachy16388963po_achy
pocks135022963pocks_
pods76540153po_ds_
poems95715553poems_
poesy105014063po_esy
poetess938933poetess
poetise9314043poetise
poets76024443poets_
poh86740533po___h
pois66539043po_is_
poise75127893po_ise
poisha1135723po_isha
pokes116133013pokes_
polar75623453pola_r
polars84419353polars
poles75351003poles_
polis74731163polis_
polkas1239103polkas_
polls74627723polls_
polos76129913polos_
pols66044563po_ls_
polys105718763polys_
pomace123111913pomace
pomade113611333pomade
pomes94833933pomes_
pomos95321583pomos_
pomps115316193pomps_
poms87037743po_ms_
ponds85323403ponds_
pones74547043pones_
pongs85526343pongs_
pons65850603po_ns_
pontes83627853pontes_
pooch124815303po_och
poods85124753poods_
poofs105222793poofs_
pooftah1543143poofta_h
pooftahs1642363pooftahs
pooh96027383po__oh
poohs103915713poohs_
pools74427703pools_
poons75430973poons_
poops94422413poops_
poorish123712303poorish
poos65949113po_os_
popes95933813popes_
poppas93710713poppas_
pops86340953po_ps_
popsy125713403po_psy
porch125918623po_rch
pores75849033pores_
porism104518063porism
porks115124143porks_
porns75527343porns_
porose84818743porose
portage103013643portage
portal84218463porta_l
portals94015563portals
ports75934593ports_
posada937163posada
pose66441733po__se
poses74642763poses_
posse74722273po_sse
post67953363po__st
postage103214853postage
postal84317533posta_l
postals93716373postals
postbase1246443postbase
postcrash1643493postcrash
posts75228783posts_
posy96028423po__sy
pot58078433pot___
potable112115363potable
potages102416423potages
potamic13310853potamic
potassic1244923potassic
potboy1397813potboy
poteen83514263poteen
potent84223353potent
potful1138083potful
pother113818853pother
pothos114214693pothos
potiche1438043potiche
potion84519573potion
potlache15114283potlache
potlatch1543133potlatch
potman102813573potman
potmen102713093potmen
potpie103412433potpie
potshot1249733pot_shot
potsie83916033potsie
pottage103310603pottage
potted94624013potted
potter83926983potter
pottle84416103pottle
potto75320943pot_to
pottos84615873pottos
potty105621003pot_ty
potzer174411213potzer
pouch124617083po_uch
poufs105616063poufs_
pours74623183pours_
pouts75530323pouts_
pows95537663po_ws_
poxes145325723poxes_
prase76128753p_rase
prats76333393prats_
preach133613923preach
prewash1535213prewash
proas75028803proas_
protases102115033protases
protasis102411973protasis
proteas92015123proteas_
protease10209893protease
protest9317533protest
protist9320223protist
prutah1136583pruta_h
psoas75012983psoas_
pujah17478543puja_h
pujahs18404943pujahs
pujas145513323pujas_
pumas95121563pumas_
punas74826753punas_
punish111411503punish
pupas95219283pupas_
push95526623p__ush
puts65641753put_s_
putsch1334933putsch
putts75719273putts_
pyas96225703p_yas_
quash174512163_quash
quotas15339433quotas_
rash76039933__rash
rehash1237433rehash
rewash1237673rewash
roach105717003ro_ach
roast56230143ro_ast
rota45834343rota__
rotary92411303rotary
rotate63320343rotate
rotch105815933rot_ch
rotes56143903rotes_
rotis56327063rotis_
rotls55620163rotls_
rotos56027883rotos_
rots46454093rot_s_
sapotas939613sapotas_
sash77235303__sash
slash84719683_slash
smash104814433_smash
snash84815673_snash
sobas74424253sobas_
socas74026183socas_
sodas64123543sodas_
sofas85320713sofas_
softas94410403softas_
softish13127813softish
sojas124716393sojas_
somas76030373somas_
soras55041013soras_
soth75932523sot__h
soths86218633soths_
sots45552453sot_s_
sottish10129443sottish
soyas84520913soyas_
splash1168823splash
spots74424113spot_s_
squash1846833squash
staph104314653_staph
stoas55126023stoas_
swash116316753_swash
tach96132753__tach
tas38477103__tas_
task85326653__task
tass45640573__tass
thrash12258363thrash
toast55831013to_ast
toeas55726423toeas_
togas67823003togas_
tolas54532773tolas_
tonish93415903tonish
torah87125273tora_h
torahs95115643torahs
toras55540373toras_
tortas64918253tortas_
tosh74826813__tosh
total55321823tota_l
totals63115163totals
totes55139683totes_
tots46654123tot_s_
toyish122911123toyish
trash86119763_trash
tush74523903__tush
unlash938793unlash
utas45924953_utas_
votary12248333votary
votes84627083votes_
wash106033813__wash
woosh113710733wo_osh
wots76342893wot_s_
yogas96615603yogas_
zetas145018163zetas_
zoeas145815613zoeas_

Search took 6 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.390458182.1
2DLD Change Limit1127164525.31321215.1
3Display Results4524520.1403228.6
 (SQL Overall)1786914525.84330582.1
 
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.