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

255 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
patacas1131100(None) 
pataca10311191pataca_
abacas104414722_abacas
maracas11313772maracas
pacas96029402p__acas
pajamas18278152pajamas
palaces114216462palaces
palapas11311492palapas
panaceas1236762panaceas
panadas103312212panadas
panamas113112762panamas
papayas1437272papayas
patamar1147092patamar
patamars1246842patamars
patinas96318522patinas
pitayas1286262pitayas
sataras7315062sataras
abaca95118043_abaca_
abacus10349763_abacus
abakas123911743_abakas
abayas114011703_abayas
acacias11510403_acacias
agamas97413453_agamas
alpacas1137073alpacas
anabas8314083_anabas
arecas84817443_arecas
asanas6514113_asanas
atabal839743_atabal
atabals938413_atabals
ataman81013063_ataman
atamans9710433_atamans
ataps76414833_ata_ps
ataxias14189343_ataxias
atlas55821583_at_las
atmas75721013_at_mas
attacks13126943attacks
balatas9311833balatas
bananas93312223bananas
barcas101016603ba_rcas
cabalas113516003cabalas
cabanas112413033cabanas
cacas95627983__cacas
cantalas104013523cantalas
cantatas103410093cantatas
caracal11312513caracal
caracals12310763caracals
caracks152211563caracks
casabas1139983casabas
casavas1237823casavas
catalase1039223catalase
catalos9414163catalos
catalpas1246733catalpas
catawbas1544093catawbas
catenas9313113catenas
catfaces1536963catfaces
cloacas1136233cloacas
database1143533database
datchas1347423datchas
daturas838783daturas
fatbacks1946003fatbacks
fatwas1249053fat_was
fracas11311993_fracas
haftaras14136073haftaras
halachas16317893halachas
halalas104214083halalas
hamadas1339673hamadas
hatracks1737533hatracks
hawalas13348353hawalas
hepaticas16166583hepaticas
jacanas1638263jacanas
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kamalas13339123kamalas
kanakas10327213kanakas
katas95922093kat__as
lantanas838263lantanas
latakias1245583latakias
latices9313763latices
latinas74416463latinas
latrias71913213latrias
macacos1338083macacos
malaccas1445163malaccas
mananas93414733mananas
maraca10314153maraca_
marascas1247383marascas
masalas9312063masalas
mastabas1246803mastabas
matzas1749703mat_zas
naganas847983naganas
ottavas1093483ottavas
outacts9310213outacts
paca85132243p__aca_
paces96741113p__aces
pachas135017143pa_chas
packs135528933p__acks
pacs85842183p__ac_s
pacts95125803p__acts
padauks1443943padauks
paeans85118263paea_ns
paellas9411413paellas
pagans95717923paga_ns
pagodas11367553pagodas
paisanas10288873paisanas
paisas84317493pa_isas
pajama17317653pajama_
pakehas1635313pakehas
pakoras1337473pakoras
palabras1267353palabras
palace104516923palac_e
palaced124110783palaced
palais8420423pala_is
palapa10310673palapa_
palatal9310153palatal
palatals1037773palatals
palates93624943palates
pampas124913993pa_mpas
panacea1137793panacea
panacean1244733panacean
panache1458433panache
panaches15310293panaches
panada94113053panada_
panama104213353panama_
pandas95521963pa_ndas
pangas99921113pa_ngas
panics103815363panic_s
panochas1545653panochas
papacies1439483papacies
papacy1547493papac_y
papadam1486913papadam
papadams15104783papadams
papains11312363papains
papas94927493p__apas
papaws13419113papa_ws
papaya1337503papaya_
papayan1445303papayan
papricas1447053papricas
parades104121463parades
parados103816053parados
paramos113213513paramos
parangs104314373parangs
paraphs1439313paraphs
paras76143043p__aras
parkas125018023pa_rkas
partakes1449923partakes
partans94418283parta_ns
partitas10310253partitas
paruras9310533paruras
pascal10812373pa_scal
pascals11610013pascals
pashas115117063pa_shas
pastas85422873pa_stas
pastinas103712153pastinas
patagia1068783patagia
patagial1157173patagial
patch125221223pat_c_h
patches143320383patches
patchy16509573pat_chy
patellas1039103patellas
patens84820863pat_ens
patents94815203patents
paters84935833pat_ers
pates76047893pat__es
pathos115516693pat_hos
paths105521383pat__hs
pathway1844853pathway
pathways1944273pathways
patina86022193patina_
patinae95414403patinae
patines95225763patines
patins87528783pat_ins
patios85221783pat_ios
patness92912283patness
patois84319363pat_ois
patrols93513513patrols
patrons93818103patrons
pats66460853pat___s
patsies93919483patsies
pattamar1243153pattamar
pattamars1342903pattamars
pattens95414923pattens
patters94825193patters
patties93425143patties
patzers184210573patzers
pavanes123612653pavanes
pavans115715593pava_ns
paybacks2145493paybacks
payolas12148973payolas
peaces106324083p_eaces
petals84719813peta_ls
petards104311153petards
petasos948603petasos
petasus946363petasus
piasabas1243883piasabas
piasavas1343333piasavas
picaras11311283picaras
picas94626523p__icas
pinatas93711503pinatas
pintadas11105083pintadas
piranas9912603piranas
pirayas1277483pirayas
pitapat1149163pitapat
pitapats1244443pitapats
pitas77427673pit__as
pitaya1186603pitaya_
pittas86014523pit_tas
places104323703p_laces
placks144414153p_lacks
platanes102711883platanes
platans93413123plata_ns
platinas103610313platinas
playacts1543813playacts
playas114612283p_layas
plazas17409913p_lazas
pomaces132712123pomaces
posadas1037193posadas
potages102416423potages
preacts113211363preacts
puranas9712643puranas
pyjamas21263523pyjamas
qabalas18289503qabalas
ramadas1039303ramadas
ratafias1145323ratafias
ratals64219583rata_ls
ratans63819373rata_ns
ratatat7412263ratatat
ratatats846063ratatats
retacks132210713retacks
samaras9312913samaras
satangs8479713satangs
satara6315533satara_
satays94411683sata_ys
spatulas1045473spatulas
stacks124317263_stacks
taces76237803__taces
tachs105820933__tachs
tacks115430133__tacks
tacos77023553__tacos
tacts76524123__tacts
takas95520683__takas
talas55935893__talas
tantaras8269543tantaras
tapas74627713__tapas
taramas9612703taramas
tartanas8258893tartanas
tatamis939723tatamis
tatars64619793tata_rs
tuataras844863tuataras
untacks1357503untacks
vatical1239983vatical
watapes12228383watapes
wataps11248683wata_ps
yatagan1144133yatagan
yatagans1244083yatagans
zananas16319563zananas

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272556.78319759.3
3Display Results2552550.0932741.9
 (SQL Overall)1786912557.28224538.7
 
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.