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

265 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
pact8664872(None) 
act59557841_act
epact94921531epact
fact97142541fact
pac79054081pac_
paca85132241paca
pace86345771pace
pack125535441pack
pacs85842181pacs
pacts95125801pacts
pacy115328681pacy
pant66061261pant
part65967461part
past65959011past
pat58089461pa_t
tact67349031tact
ace59656832_ace
acta69524802_acta
acts66929862_acts
aft66849012_aft
ait38093902_ait
alt36467962_alt
ant37270792_ant
apace94718382apace
apart74330672apart
apt57352542_apt
art38679142_art
at212393402_a_t
att35454652_att
bach116131392bach
back125535762back
baht96740012baht
bait66556002bait
bast66362412bast
bat510988952ba_t
batt65053872batt
bract96332722bract
caca85528082caca
cacti9318642cacti
cant66362032cant
cart66570342cart
cast67159902cast
cat58282342ca_t
coact96130582coact
dace76934922dace
daft85537252daft
dart55857872dart
daut56443562daut
dawt85435942dawt
duct75735462duct
each95530582each
east46659102east
eat36989052ea_t
enact73525362enact
epacts105010392epacts
exact143516932exact
face96140122face
facet106038522facet
facts107021892facts
fart76860562fart
fast77052312fast
fat68178082fa_t
gait56150192gait
gast56052562gast
gat46880512ga_t
hack135134542hack
haet75659502haet
haft105941842haft
halt76056302halt
hant75461592hant
hart76865772hart
hast76259482hast
hat67289962ha_t
haut75949732haut
impact122310452impact
jack175224862jack
kart86750802kart
kat77468292ka_t
lac510155822lac_
lace66848472lace
lack105837682lack
lacs66942482lacs
lacy95829632lacy
last46260322last
lat37593402la_t
mac78053932mac_
mace87345792mace
mach116134482mach
mack125733652mack
macs86742512macs
malt66254812malt
mart66865982mart
mast65959962mast
mat58083942ma_t
matt65752662matt
maut65448452maut
oast47156322oast
oat39888262oa_t
pa410456482pa__
pacas96029402pacas
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
pacha126518062pacha
packet144726502packet
packs135528932packs
pad68057322pa_d
padi76331782padi
pads76742952pads
page76036102page
pah88853592pa_h
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
paint75443692paint
pair66031512pair
pal56761672pa_l
pale66055012pale
palet74650802palet
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pam77858392pa_m
pams85641762pams
pan58466452pa_n
pane64950292pane
pang75336292pang
pans65855732pans
panto76129412panto
pants76536922pants
panty105929302panty
pap76758402pa_p
papa85827142papa
paps86443452paps
par57467022pa_r
para65242172para
parch125123002parch
pard76441322pard
pare66760842pare
park105237492park
parr65731152parr
pars67560792pars
parts77743372parts
party106630612party
pas58775742pa_s
pase65346862pase
pash95638132pash
pass65239952pass
pasta76624532pasta
paste74932952paste
pasts75936502pasts
pasty105725052pasty
patch125221222patch
pate65350462pate
path99134912path
pats66460852pats
patty104723612patty
paty95234562paty
pave96133892pave
paw87651172pa_w
pawl95123262pawl
pawn94625302pawn
paws96038182paws
pax127346852pa_x
pay88461182pa_y
pays95940222pays
peace95026082peace
peach125422492peach
peart76440752peart
peat65967932peat
pec76744412pec_
pech116125452pech
peck125730682peck
pecs84634102pecs
pelt67651082pelt
pent66559072pent
pert66759322pert
pest65555292pest
pet56477302p_et
pfft12311882pfft
phat95837862phat
phot95534362phot
pht86030522p_ht
phut96925972phut
pic76046822pic_
pica85831492pica
pice84641092pice
pick125933812pick
picot95031012picot
pics85633912pics
pint66963172pint
pit56471922p_it
place94824612place
placet103923672placet
plack135017842plack
plait75631572plait
plant75437112plant
plat66048872plat
plot66141232plot
poach124917862poach
pock126129292pock
poco86826152poco
poet65552902poet
port66059632port
post67953362post
pot58078432p_ot
pout65752552pout
prat65952042prat
preact103220392preact
psst66118402psst
pst57932512p_st
puce85127882puce
puck124927942puck
punt65747202punt
put55759072p_ut
putt66937842putt
qat125253332qa_t
race66746262race
rack106234882rack
racy95825682racy
raft76245912raft
rant45864682rant
rapt67245312rapt
rat37892742ra_t
react74634332react
sac57452862sac_
sack105337312sack
sacs65739072sacs
salt45758522salt
sat36288482sa_t
scat65848372scat
sect67443622sect
space95325672space
spacy125415622spacy
spait75631602spait
spat66548522spa_t
tace65342512tace
tacet75840022tacet
tach96132752tach
tacit76333672tacit
tack106536292tack
taco67031352taco
tacts76524122tacts
tart47566182tart
tat37690292ta_t
taut47048962taut
tract75635712tract
vac86537142vac_
vacs96226202vacs
vast75045122vast
vat67863452va_t
wack135330912wack
waft106139002waft
wait75553692wait
want76156172want
wart77866082wart
wast75655852wast
wat67378922wa_t
watt75545412watt
yacht13417392yacht
yack135425972yack

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.310576422.6
2DLD Change Limit298722650.95331345.2
3Display Results2652650.0634206.3
 (SQL Overall)1786912651.326134759.4
 
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.