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

209 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
pacas9602940(None) 
cacas95627981cacas
paca85132241paca_
paces96741111paces
pachas135017141pachas
packs135528931packs
pacs85842181pac_s
pacts95125801pacts
papas94927491papas
paras76143041paras
picas94626521picas
aas310975392_a_as
abacas104414722abacas
abas68642082_abas
aces67645092_aces
acts66929862_acts
agas55938842_agas
alas46358122_alas
alpacas1137072alpacas
amas67746292_amas
anas46649862_anas
baas66844672ba_as
babas96325732babas
backs135729622backs
balas76937212balas
barcas101016602barcas
caca85528082caca_
cacao95420002cacao
cacaos104616182cacaos
camas96333522camas
casas75327842casas
cocas95926572cocas
cycas126513822cycas
daces85030682daces
dachas124113252dachas
dadas75819862dadas
epacts105010392epacts
faces106439432faces
facias113415802facias
facts107021892facts
favas115618592favas
fracas11311992fracas
galas65731642galas
gamas85431362gamas
hacks144928712hacks
hahas117118442hahas
jacal14313702jacal
jacals1539872jacals
jacks185219832jacks
javas155915422javas
kaas86531842ka_as
kakas85117342kakas
kanas95326912kanas
kapas116021732kapas
katas95922092katas
kavas125919952kavas
laces76141762laces
lacks116129202lacks
lacs66942482lac_s
lamas75532792lamas
lavas85422222lavas
macaw12311762macaw
macaws1337022macaws
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512mac_s
mamas95930772mamas
manas76240432manas
maras75443292maras
masas75630412masas
mayas105924382mayas
micas96823052micas
nachas114914192nachas
nadas66320812nadas
nalas55528362nalas
nanas55928632nanas
napas75924352napas
ocas66729632_ocas
orcas75918622orcas
pac79054082pac__
pace86345772pac_e
paced106931682paced
pacer96131612pacer
pacers105124542pacers
pacey126720282pacey
pacha126518062pacha
pack125535442pac_k
pact86648722pac_t
pacy115328682pac_y
padis86227142padis
pads76742952pa_ds
paean77222722paean
paeans85118262paeans
pagan86121162pagan
pagans95717922pagans
pages85235072pages
paiks114719852paiks
pails75833062pails
pains75138282pains
pairs75325832pairs
paisa76021072paisa
paisas84317492paisas
palais8420422palais
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pampas124913992pampas
pams85641762pa_ms
pandas95521962pandas
panes76148692panes
pangas99921102pangas
pangs84628662pangs
pans65855732pa_ns
pants76536922pants
papa85827142papa_
papal95820672papal
papaw125112492papaw
papaws13419112papaws
paps86443452pa_ps
para65242172para_
parae76335702parae
pards85634332pards
pares77164482pares
paris75145942paris
parkas125018022parkas
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
pas58775742p__as
pascal10812372pascal
pascals11610012pascals
pases75346502pases
pashas115117062pashas
pass65239952pa_ss
pastas85422872pastas
pasts75936502pasts
patacas11311002patacas
pates76047892pates
paths105521382paths
pats66460852pa_ts
pavan106518472pavan
pavans115715592pavans
paves104833922paves
pavis106422732pavis
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
peaces106324082peaces
peas65755062p_eas
pecan91919032pecan
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pias66542552p_ias
pica85831492pica_
pical95524372pical
picks135226142picks
pics85633912pic_s
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
places104323702places
placks144414152placks
playas114612282playas
plazas17409912plazas
pleas75627032pleas
pocks135022962pocks
proas75028802proas
psoas75012982psoas
puces94924632puces
pucks134322102pucks
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
pyas96225702p_yas
races74943242races
racks115028852racks
ragas65326062ragas
raias54631122raias
rajas127317722rajas
rayas85922052rayas
sacks114228872sacks
sacs65739072sac_s
sagas66025882sagas
socas74026182socas
spaces104722632spaces
spicas104715822spicas
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
takas95520682takas
talas55935892talas
tapas74627712tapas
vacs96226202vac_s
varas86028192varas
wacks146626282wacks
yacks144419812yacks
yucas106013912yucas

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 Filter178691538000.313570897.8
2DLD Change Limit538002091.42337807.4
3Display Results2092090.0603483.3
 (SQL Overall)1786912091.79699493.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.