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

252 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
picaras1131128(None) 
picara10311901picara_
picaros11310891picaros
bicarbs1336012bicarbs
cicadas1235992cicadas
cicalas1139302cicalas
epicarps1444782epicarps
jicamas1845052jicamas
kinaras1159122kinaras
paras76143042p__aras
picaro10311322picar_o
picas94626522pic__as
pinatas93711502pinatas
piranas9912602piranas
pirayas1277482pirayas
pitayas1286262pitayas
tiaras6314552ti_aras
vicars11712262vicar_s
acarus8312193_acarus
apicals1159923apica_ls
apocarps1474423apocarps
ascaris93613323ascaris
baccaras1446913baccaras
bicarb1238543bicar_b
bicorns11338763bicorns
bidarkas1543363bidarkas
buckras1537343buckras
cacas95627983__cacas
camas96333523__camas
carat75048793__carat
carats85929023__carats
carbs96031463__carbs
cards85137933__cards
cares77369183__cares
carks115534213__carks
carls77037423__carls
carns75937563__carns
carps96932253__carps
carrs75730853__carrs
cars67364763__car_s
carts78946293__carts
casas75327843__casas
cascaras1237703cascaras
charas114223613_charas
cicada1136413cicada_
cicadae1244853cicadae
cicala10310053cicala_
ciceros1158583ciceros
cigars9910723cigar_s
citharas13156723citharas
curaras93911953curaras
decares102818533decares
dicambas1553793dicambas
dicasts1078703dicasts
dicers94720743dicer_s
dinars75417563dinar_s
disarms1039043disarms
discards1238913discards
epicarp1376073epicar_p
epicures1246513epicures
escarps11397373escarps
escars83913133escar_s
fiacres1237253fiacres
fiars86720833fi_ar_s
hijras1635773hi_jras
inarms8410093_inarms
ixoras1337193_ixoras
izars145112933_izar_s
jacanas1638263jacanas
jicama1734883jicama_
kinara10310373kinara_
kitharas15165413kitharas
lianas63713383li_anas
liards75212613li_ards
liars54723163li_ar_s
libras83711703li_bras
lidars7310783lidar_s
liras56021983li__ras
lizards17427613lizards
lycras11287253lyc_ras
maras75443293__maras
mascaras1237693mascaras
micas96823053mic__as
micra96214973mic_ra_
micros104115363mic_ros
nicads938333nica_ds
oxcarts1634313oxcarts
pacas96029403p__acas
pacers105124543pacer_s
pachas135017143pac_has
paisanas10288873paisanas
pajamas18278153pajamas
pakoras1337473pakoras
palabras1267353palabras
palapas11311493palapas
panadas103312213panadas
panamas113112763panamas
papas94927493p__apas
papayas1437273papayas
para65242173p__ara_
parae76335703p__arae
pards85634333p__ards
pares77164483p__ares
paris75145943p__aris
parkas125018023p__arkas
parks116134463p__arks
parrs75928673p__arrs
pars67560793p__ar_s
parts77743373p__arts
paruras9310533paruras
patacas11311003patacas
pearls84715393p_earls
pears75138613p_ear_s
pecans101515833peca_ns
pericarps1544473pericarps
petards104311153petards
pharos11312063p_haros
pianos84315933pi_anos
pians75126963pi_a_ns
pias66542553pi___as
piasabas1243883piasabas
piasavas1343333piasavas
piazzas1743643piazzas
pibals103813083piba_ls
pica85831493pic__a_
picacho1644733picacho
picachos1744523picachos
picador1245923picador
picadores1444363picadores
picadors1345853picadors
pical95524373pic__al
picante11310523picante
picaroon1245653picaroon
picaroons1344673picaroons
piccata1345703piccata_
piceous11310693piceous
pickax2135913pic_kax
pickaxes2344913pickaxes
pickers153718093pickers
pickets154314183pickets
pickles153215443pickles
picks135226143pic__ks
pickups1754253pickups
picloram1445913picloram
piclorams1544163piclorams
picnics13297343picnics
picofarad1752173picofarad
picofarads1851533picofarads
picogram1546523picogram
picograms1645723picograms
picots104616443pic_ots
picrate112014143picrate
picrates122013213picrates
picric12309923pic_ric
pics85633913pic___s
pictures1249343pictures
piculs103511753pic_uls
piecers114112253piecer_s
piers75926333pi_er_s
pietas84516503pi_etas
pikakes1245823pikakes
pikas114218093pi__kas
pikers124717393piker_s
pilaffs15365153pilaffs
pilafs113511023pila_fs
pilar75221503pilar__
pilaus84114133pila_us
pilaws11399433pila_ws
pilchards1743923pilchards
pillars9313493pillar_s
pimas94725103pi__mas
pinangs10267793pinangs
pinas75434453pi__nas
pinata83817223pinata_
pincers113916503pincer_s
pingrass1146003pingrass
pinnas85315513pi_nnas
pintadas11105083pintadas
pintas85021393pi_ntas
pipages1289423pipages
pipals104213643pipa_ls
pipers104318663piper_s
piraguas1144453piraguas
pirana8713263pirana_
piranhas13135873piranhas
pirates93020333pirates
piraya1167713piraya_
pirns76020093pi__rns
piscaries13410073piscaries
piscary1437423piscar_y
piscinas1275483piscinas
pitapat1149163pitapat
pitapats1244443pitapats
pitas77427673pi__tas
pitaya1186603pitaya_
pittas86014523pi_ttas
pizzas1646983pi_zzas
placards1345813placards
playas114612283p_layas
plazas17409913p_lazas
pleuras937413pleuras
pochards1646853pochards
podagras1244053podagras
polars84419353polar_s
posadas1037193posadas
prearms11369173prearms
pricers113915063pricer_s
procarps1445973procarps
puranas9712643puranas
pyjamas21263523pyjamas
riatas63915093ri_atas
ricers84120993ricer_s
ricrac1037013ric_rac
ricracs1136363ricracs
ristras7311563ristras
ritards8439943ritards
samaras9312913samaras
sataras7315063sataras
scarab10310063_scarab
scarabs1137293_scarabs
scares85033003_scares
scarfs114714683_scarfs
scarps104718603_scarps
scars75433533_scar_s
scarts85321493_scarts
sierras737863sierras
sifakas1443333sifakas
simars84916933simar_s
sirras63814863si_rras
sitars65417593sitar_s
sizars154812623sizar_s
spicas104715823spic__as
spicers113815553spicer_s
spiraeas10286233spiraeas
tiara5315913ti_ara_
ticals83214713tica_ls
timarau975853timarau
timaraus1095073timaraus
tipcarts1244573tipcarts
varas86028193__varas
vicar10513863vicar__
vicarage1444433vicarage
vicarages1574433vicarages
vicarate1378603vicarate
vicarates1487623vicarates
vicarial1347793vicarial
vicarly1536463vicarly
vicunas1285613vicunas
visards11328153visards
vizards20377263vizards
wiccas1336543wic_cas
wizards20326403wizards

Search took 9 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.453394461.4
2DLD Change Limit1340272528.18616372.7
3Display Results2522520.283890.5
 (SQL Overall)1786912528.92220028.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.