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

299 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
picaro1031132(None) 
picara10311901picara
picaros11310891picaros
bicarb1238542bicarb
cicero1048502cicero
epicarp1376072epicarp
micro94715992mic_ro
piano76118712pi_ano
pica85831492pica__
picacho1644722picacho
picador1245922picador
pical95524372pica_l
picaras11311272picaras
picaroon1245652picaroon
picas94626522pica_s
pilar75221502pilar_
piscary1437422piscary
vicar10513862vicar_
vicars11712262vicars
acari75020283_acari
apiary113910383api_ary
apical10913903apica_l
apicals1159923apicals
apocarp1355133apocarp
bicarbs1336013bicarbs
bicorn103610103bicorn
bicron103710773bic_ron
binary11312223binary
biro66131203bi__ro
bistro8339943bistro
bizarro1843333bizarro
cacao95420003caca_o
calo64936443__calo
camo85731753__camo
capo85829213__capo
car59165563__car_
carb85143163__carb
carbo94923843__carbo
card710245873__card
care66968373__care
cargo85322073__cargo
cark105539273__cark
carl65144783__carl
carn66245433__carn
carob95325223__carob
carol75128613__carol
carom95025563__carom
carp85139813__carp
carr65434703__carr
cars67364763__cars
cart66570343__cart
cero66329453__cero
chicano1496863chicano
ciao64924183ci_a_o
cicada1136413cicada
cicala10310053cicala
cicale10314503cicale
ciceros1158573ciceros
cigar8911793cigar_
cigars9910713cigars
claro75018693_claro
decare93919153decare
diary95016973di_ary
diazo15310033di_azo
dicast9315573dicast
dicer85426423dicer_
dicers94720743dicers
dinar66319893dinar_
dinars75417563dinars
dinero75612643dinero
disarm9310473disarm
discard11310213discard
epical10413393epica_l
epicarps1444783epicarps
epicure1136823epicure
escar74011993escar_
escarp10449003escarp
escars83913133escars
faro76136923__faro
fiacre1137623fiacre
fiar76427333fi_ar_
fiars86720833fi_ars
fico95824583fic__o
filar84819293filar_
giro55828633gi__ro
gitano738043gitano
hilar85418143hilar_
ichor1039473_ichor
imago8118683_imago
inarm7314423_inarm
inro45920793_i_nro
intro54915853_intro
izar136616013_izar_
izars145112933_izars
jiao115017843ji_a_o
jicama1734873jicama
kinara10310363kinara
liar47229683li_ar_
liard65418593li_ard
liars54723163li_ars
lictor83610853lictor
lidar6312723lidar_
lidars7310783lidars
lizard16369233lizard
macaco1247853macaco
macro94718173mac_ro
mica86428243mica__
micas96823053mica_s
micra96214973mic_ra
micron103714283mic_ron
micros104115363mic_ros
mikado1344513mikado
mucro94513723muc_ro
nicad8312613nica_d
nicads938333nicads
nicer74618293nicer_
nitro54914353ni_tro
oxcart1539523oxcart
paca85132243paca__
pacas96029403paca_s
pacer96131613pacer_
pacers105124543pacers
paisano9429513paisano
par57467023p__ar_
para65242173p__ara
paramo102614643paramo
pard76441323p__ard
pare66760843p__are
pareo74632603p__areo
pargo86723723p__argo
park105237493p__ark
parol74826273p__arol
parr65731153p__arr
pars67560793p__ars
part65967463p__art
parvo107719183p__arvo
pear69745233p_ear_
pearl75324463p_earl
pears75138613p_ears
peart76440753p_eart
pecan91919033peca_n
pecans101515833pecans
peccary1636283peccary
pedalo93811143pedalo
pedro8313153p_edro
pericarp1446123pericarp
petard95013803petard
pharos11312063p_haros
pia56848033pi_a__
pial65636703pi_a_l
pian66136093pi_a_n
pianos84315933pi_anos
pians75126963pi_ans
pias66542553pi_a_s
pibal95217323piba_l
pibals103813083pibals
pic76046823pic___
picachos1744523picachos
picadors1345833picadors
picante11310523picante
picaroons1344673picaroons
piccata1345703piccata
piccolo1354393piccolo
pice84641093pic__e
pick125933813pic__k
pickaroon1752893pickaroon
pickax2135913pickax
pickaxe2244623pickaxe
picked154421313picked
picker144422173picker
pickers153718093pickers
picket144924313picket
pickle144215653pickle
picks135226143pic_ks
pickup1655633pickup
picky165416943pic_ky
picnic123410263picnic
picot95031013pic_ot
picots104616443picots
picrate112014143picrate
picric12309923picric
pics85633913pic__s
picture1158613picture
picul95015363pic_ul
piculs103511753piculs
piecer105213083piecer_
piecers114112253piecers
pier66035293pi_er_
pierrot948833pierrot
piers75926333pi_ers
pika106322953pika__
pikake11115803pikake
pikas114218093pika_s
piker115622843piker_
pikers124717393pikers
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
pilchard1644553pilchard
pillar8314023pillar_
pillars9313483pillars
pima85428653pima__
pimas94725103pima_s
pina65842633pina__
pinang92611593pinang
pinas75434453pina_s
pinata83817213pinata
pincer104019173pincer_
pincers113916503pincers
pinery115214283pinery
pingo87122713pi_ngo
pinko115618253pi_nko
pintado1096573pintado
pintano998993pintano
pinto75625753pi_nto
pipage1199143pipage
pipal95118353pipa_l
pipals104213643pipals
piper96523193piper_
pipers104318663pipers
piracy1339473piracy
pirana8713263pirana
pirate82322883pirate
piraya1167713piraya
pirn67128373pi__rn
pirog83913673pi__rog
piscator1246923piscator
pisco96314983pi_sco
piso66727563pi__so
pita65436433pita__
pitas77427673pita_s
pitaya1186603pitaya
pizazz1554223pizazz
placard1236783placard
plica9613373plica__
plicae10410953plica_e
plical10411683plica_l
plicate11314513plicate
pochard1537363pochard
poco86826153poc__o
polar75623453polar_
polaron939843polaron
polars84419353polars
potato8513433potato
prao66229023p_ra_o
prearm104512343prearm
pricer103918293pricer_
pricers113915063pricers
primary1437703primary
primero11368923primero
pro55837263p___ro
procarp1346823procarp
pyro96019393p__yro
ricer74726613ricer_
ricers84120993ricers
ricrac1037013ricrac
ritard74812083ritard
scar66434203_scar_
scare75334463_scare
scarf105427143_scarf
scarp95724103_scarp
scars75433533_scars
scart76139773_scart
scary105222593_scary
sicko115315393sic_ko
simar74920813simar_
simars84916933simars
sitar54820543sitar_
sitars65417593sitars
sizar145214993sizar_
sizars154812623sizars
spica94717943spica__
spicae104313703spica_e
spicas104715823spica_s
spicate113214193spicate
spiccato1463183spiccato
spicer104719313spicer_
spicers113815553spicers
spicery14499013spicery
taro46846913__taro
tiara5315903ti_ara
tical76021493tica_l
ticals83214713ticals
tipcart1148833tipcart
tiro46832363ti__ro
vicarly1536463vicarly
viceroy1544933viceroy
victor113210673victor
virago1046643virago
visard103910123visard
vivary1536983vivary
vizard19458853vizard
wizard19377713wizard
zingaro1745113zingaro
zocalo1735803zocalo

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162996.68616858.5
3Display Results2992990.0803737.5
 (SQL Overall)1786912996.90625874.7
 
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.