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

404 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
part6596746(None) 
apart74330671apart
art38679141_art
cart66570341cart
dart55857871dart
fart76860561fart
hart76865771hart
kart86750801kart
mart66865971mart
pact86648721pact
pant66061251pant
par57467021par_
para65242171para
pard76441321pard
pare66760841pare
park105237491park
parr65731151parr
pars67560791pars
parts77743371parts
party106630611party
past65959011past
pat58089461pa_t
peart76440751peart
pert66759321pert
port66059631port
prat65952041prat
tart47566181tart
wart77866081wart
act59557842_act
aft66849012_aft
airt45757782airt
ait38093902_ait
alt36467962_alt
ant37270782_ant
aport75432172aport
apt57352542_apt
ar211379382_ar_
arb510448422_arb
arc510250902_arc
are37874572_are
arf67453372_arf
ark77044962_ark
arm58449622_arm
ars37670932_ars
arts49650262_arts
arty77531312_arty
at212393402_a_t
att35454652_att
baht96740012baht
bait66556002bait
bar58070552bar_
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
bast66362412bast
bat510988952ba_t
batt65053872batt
boart78835932boart
bort65960962bort
brat66055542brat
cant66362022cant
car59165562car_
carat75048792carat
carb85143162carb
card710245872card
care66968372care
caret75360562caret
cark105539272cark
carl65144782carl
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carte75940422carte
carts78946292carts
cast67159902cast
cat58282342ca_t
chart105038282chart
curt67051712curt
daft85537252daft
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
darts67635732darts
daut56443562daut
dawt85435942dawt
depart94720562depart
dirt55550382dirt
drat56247832drat
ear36867882ear_
earl45838142earl
earn46737552earn
ears46356592ears
earth85023052earth
east46659102east
eat36989052ea_t
epact94921532epact
fact97142542fact
far67762602far_
fard85639062fard
fare76354462fare
farl76338552farl
farm95934532farm
faro76136922faro
farts88336842farts
fast77052312fast
fat68178082fa_t
fort76456442fort
frat75648542frat
gait56150192gait
gar47259902gar_
garb75332672garb
gars55750742gars
garth94720222garth
gast56052562gast
gat46880512ga_t
girt56646422girt
grat55651282grat
haet75659502haet
haft105941842haft
halt76056302halt
hant75461582hant
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
harts88441592harts
hast76259482hast
hat67289962ha_t
haut75949732haut
heart85440742heart
hurt77142572hurt
impart102715142impart
jar107646152jar_
jarl115828132jarl
jars117338352jars
karat96837592karat
karn86129412karn
karst97228992karst
karts97630112karts
kat77468292ka_t
lar37967532lar_
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
last46260322last
lat37593402la_t
lyart85121882lyart
malt66254802malt
mar57965942mar_
mara67444562mara
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
mars66261862mars
marts77442232marts
mast65959952mast
mat58083932ma_t
matt65752652matt
maut65448442maut
mort66758832mort
narc67127952narc
nard56634452nard
nark85230062nark
nary76931222nary
oar37057952oar_
oars46846032oars
oast47156322oast
oat39888262oa_t
ort39465232_ort
pa410456482pa__
pac79054082pa_c
paca85132242paca
pace86345772pace
pack125535442pack
pacs85842182pacs
pacts95125802pacts
pacy115328682pacy
pad68057322pa_d
padi76331782padi
padre86018162padre
padri85815162padri
pads76742952pads
page76036102page
pah88853592pa_h
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
paint75443692paint
pair66031512pair
pairs75325832pairs
pal56761672pa_l
pale66055012pale
palet74650802palet
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pam77858392pa_m
pams85641762pams
pan58466442pa_n
pane64950282pane
pang75336282pang
pans65855722pans
panto76129412panto
pants76536922pants
panty105929302panty
pap76758402pa_p
papa85827142papa
paps86443452paps
parae76335702parae
paras76143042paras
parch125123002parch
pardi85723952pardi
pards85634332pards
pardy115523952pardy
pared86946762pared
parent83230422parent
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parge85831852parge
parget94529392parget
pargo86723722pargo
paris75145942paris
parity114719872parity
parka115120882parka
parks116134462parks
parle75836162parle
parol74826272parol
parrot8320662parrot
parrs75928672parrs
parry105323752parry
parse75236992parse
partan83820562partan
parted94228682parted
partly116315472partly
parton84720992parton
parve109824852parve
parvo107719182parvo
pas58775742pa_s
pase65346862pase
pash95638132pash
pass65239952pass
pasta76624532pasta
paste74932952paste
pasts75936502pasts
pasty105725052pasty
pate65350462pate
path99134912path
pats66460852pats
patty104723612patty
paty95234562paty
pave96133892pave
paw87651172pa_w
pawl95123262pawl
pawn94625302pawn
paws96038182paws
pax127346852pa_x
pay88461182pa_y
pays95940222pays
pear69745232pear_
pearl75324462pearl
pears75138612pears
peat65967932peat
pelt67651082pelt
pent66559072pent
per56353092per_
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
perv97224812perv
pest65555292pest
pet56477302p_et
pfft12311882pfft
phat95837862phat
phot95534352phot
pht86030522p_ht
phut96925972phut
pint66963172pint
pirn67128372pirn
pit56471922p_it
plait75631572plait
plant75437112plant
plat66048872plat
plot66141232plot
poet65552902poet
pore66451262pore
pork106929682pork
porn65636022porn
ports75934592ports
post67953362post
pot58078432p_ot
pout65752552pout
pram85733492pram
prao66229022prao
prate75135982prate
prats76333392prats
prau66529472prau
pray96331532pray
pro55837262p_ro
pry85728052p_ry
psst66118402psst
pst57932512p_st
punt65747202punt
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
purty105019402purty
put55759072p_ut
putt66937842putt
pyre94925552pyre
pyro96019392pyro
qat125253332qa_t
quart144027852quart
raft76245912raft
rant45864672rant
rapt67245312rapt
rare45348432rare
rat37892742ra_t
salt45758522salt
sard55344242sard
sari45444042sari
sark84938972sark
sat36288482sa_t
scart76139772scart
smart75834092smart
sort46264812sort
spait75631602spait
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spat66548522spa_t
spirt75032952spirt
sport75935982sport
sprat76635972sprat
spurt77227982spurt
start55642312start
swart86234642swart
tact67349032tact
tar37570692tar_
tare45957622tare
tarn46842722tarn
taro46846912taro
tarot55943932tarot
tarp66936412tarp
tars46763952tars
tarts57242022tarts
tarty86328182tarty
tat37690292ta_t
taut47048962taut
tort46967462tort
updart9310742updart
var66148332var_
vara75530882vara
vars75742072vars
vary105226062vary
vast75045122vast
vat67863452va_t
vert77249372vert
waft106139002waft
wait75553692wait
want76156162want
war67262422war_
ward86542252ward
ware76254722ware
wark115737772wark
warm95935672warm
warn75239322warn
warp95635002warp
wars78659802wars
warts814840402warts
warty119323822warty
wary106740012wary
wast75655852wast
wat67378922wa_t
watt75545412watt
wert79749822wert
wort76654752wort
yar67253832yar_
yard85633252yard
yare75636942yare
yarn75230042yarn
yurt76435042yurt
zarf166929122zarf

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.0802233637.5
2DLD Change Limit298724041.29623049.4
3Display Results4044040.0934344.1
 (SQL Overall)1786914041.469121641.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.