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 “pash” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

264 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
pash9563813(None) 
ash67944601_ash
bash915240161bash
cash96636281cash
dash87031631dash
fash107232291fash
gash86833021gash
hash106936501hash
lash76539651lash
mash96039401mash
pah88853591pa_h
pas58775741pas_
pase65346861pase
pasha105417181pasha
pass65239951pass
past65959011past
path99134911path
pish96127911pish
plash104616561plash
posh95427321posh
push95526621push
rash76039931rash
sash77235301sash
wash106033811wash
aah616252962_aah
aahs716428562aahs
aas310975392aas_
abash106016512abash
ah513868792_a_h
ahs68644822_ahs
apish105116632apish
apse67725382apse
as211083072_as_
ashy107717352_ashy
ask77130702_ask
asp57235342_asp
ass37844062_ass
awash116613162awash
bach116131392bach
bah87755352ba_h
bas58681752bas_
base64847022base
bask105131422bask
bass66146782bass
bast66362412bast
bath95940082bath
bosh96328972bosh
brash106221562brash
bush96630712bush
caph116623292caph
casa65630862casa
case65848082case
cask105626432cask
cast67159902cast
clash106219032clash
cosh96127622cosh
crash109120012crash
dah78148982da_h
dahs88231812dahs
dashi95013112dashi
dashy125612382dashy
deash95617242deash
dish86328332dish
each95530582each
ease45042332ease
east46659102east
easy76224492easy
eath75735662eath
fas68262932fas_
fast77052312fast
fish106926272fish
flash115716212flash
gas48870252gas_
gasp76227332gasp
gast56052562gast
gnash9449832gnash
gosh86123422gosh
gush85424002gush
hah910655222ha_h
hahs108333362hahs
harsh116418052harsh
has67372652has_
hasp96627292hasp
hast76259482hast
hath105933912hath
hush105224112hush
josh145117612josh
kaph135815752kaph
kas77058582kas_
kasha124710722kasha
lakh114919952lakh
las37281472las_
lase46148512lase
lass47444542lass
last46260322last
lath76640382lath
leash85519212leash
lush75327692lush
mach116134482mach
marsh105320852marsh
mas58175822mas_
masa65034722masa
mashy136016502mashy
mask105227362mask
mass66044942mass
mast65959962mast
math95437452math
mesh96823002mesh
mosh95227602mosh
mush94929122mush
nah69847002na_h
nosh76223542nosh
oast47156322oast
oath76132152oath
opah96218402opa_h
opahs105411982opahs
pa410456482pa__
pac79054082pa_c
paca85132242paca
pace86345772pace
pacha126518062pacha
pack125535442pack
pacs85842182pacs
pact86648722pact
pacy115328682pacy
pad68057322pa_d
padi76331782padi
pads76742952pads
page76036102page
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
paisa76021072paisa
paise75028332paise
pal56761672pa_l
pale66055012pale
palish114718272palish
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
palsy105417462palsy
paly95835532paly
pam77858392pa_m
pams85641762pams
pan58466452pa_n
pane64950292pane
pang75336292pang
pans65855732pans
pansy105717972pansy
pant66061262pant
pap76758402pa_p
papa85827142papa
paps86443452paps
par57467022pa_r
para65242172para
parch125123002parch
pard76441322pard
pare66760842pare
parish115022352parish
park105237492park
parr65731152parr
pars67560792pars
parse75236992parse
part65967462part
paseo77022512paseo
pases75346502pases
pashas115117062pashas
pashed125923142pashed
pashes115828392pashes
passe75525692passe
pasta76624532pasta
paste74932952paste
pasts75936502pasts
pasty105725052pasty
pat58089462pa_t
patch125221222patch
pate65350462pate
paths105521382paths
pats66460852pats
patsy105717202patsy
paty95234562paty
pause75021832pause
pave96133892pave
paw87651172pa_w
pawl95123262pawl
pawn94625302pawn
paws96038182paws
pax127346852pa_x
pay88461182pa_y
pays95940222pays
peach125422492peach
peas65755062peas_
pease75231112pease
pech116125452pech
peh86740962p_eh
pehs95625762pehs
pes57259782pes_
peso66925822peso
pest65555292pest
phase104617212phase
pias66542552pias_
pis56362032pis_
piso66727562piso
piss65033332piss
pith95432692pith
plashy14448872plashy
plasm94114632plasm
plush105614712plush
poach124917862poach
poh86740532p_oh
pooh96027382pooh
pose66441732pose
post67953362post
posy96028422posy
potash1138272potash
prase76128752prase
psi56621622p_si
psst66118402psst
pst57932512p_st
pugh106619232pugh
pus55547842pus_
pushy134614352pushy
puss64830132puss
pyas96225702pyas_
quash174512162quash
rah68052402ra_h
ras37575392ras_
rase46149982rase
rasp66029162rasp
rath76037662rath
resh76523452resh
rush76628182rush
sass45035622sass
sh56828522__sh
slash84719682slash
smash104814432smash
snash84815672snash
spas67036722spas_
spasm94514172spasm
splash1168822splash
stash84916972stash
swash116316752swash
tach96132752tach
tas38477102tas_
task85326652task
tass45640572tass
tosh74826812tosh
trash86119762trash
tush74523902tush
upas68322382upas_
vas67755772vas_
vasa76522972vasa
vase75629652vase
vast75045122vast
was68767562was_
washy145911842washy
wasp95626852wasp
wast75655852wast
wish107228732wish
yah99046352ya_h
zas126946832zas_

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298722640.87634100.5
3Display Results2642640.0634190.5
 (SQL Overall)1786912641.235144689.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.