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

335 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
piracy133947(None) 
curacy1339592curacy
pacy115328682p__acy
papacy1547492papacy
pirana8713262pirana
pirate82322882pirate
piraya1167712piraya
pray96331532p_ra_y
pricy124814562p_ricy
primacy1635602primacy
privacy1744232privacy
racy95825682__racy
abbacy1536623abbacy
airily93014823airily
airway1237693airway
airy75734153air__y
animacy1446103animacy
apiary113910383api_ary
ariary94114203ariary
arrack121110253arrack
array86317143arra_y
bialy105119323bi_aly
biface1358103biface
bigamy1436343bigamy
binary11312223binary
biopiracy1851573biopiracy
bipack1636523bipack
birch124914023bir_ch
brace95629273_brace
brach126123303_brach
bract96332723_bract
braky145015813_braky
braxy175410893_braxy
bray95232903_bra_y
briary114912003briary
carack142113173carack
circa9311403cir_ca
crack134120533_crack
cracky175010223_cracky
crazy195511223_crazy
deray95024183dera_y
diarchy1644673diarchy
diary95016973di_ary
didact10711203didact
digamy1335893digamy
dioecy1235543dioecy
diram84419473dira_m
dirams94413703dirams
direct93817333direct
direly10311563direly
dirty95617803dir_ty
dray85428093_dra_y
epitaxy1963563epitaxy
errancy1256363errancy
farcy135217093far_cy
firmly1436663firmly
firry115713533fir_ry
foray115023973fora_y
fray105428903_fra_y
friary124010093friary
girly94415293gir_ly
grace85124543_grace
grapy115416433_grapy
gravy125512113_gravy
gray85329893_gra_y
hijack2233673hijack
horary12310383horary
icy86322123_i__cy
irade65618153_irade
irate55627983_irate
irony85015903_irony
kirsch1532713kirsch
lacy95829633__lacy
legacy1256653legacy
library1245323library
lilac7311073lilac_
lilacs837483lilacs
linac7315413linac_
linacs8310813linacs
lira46928683lira__
liras56021983lira_s
litany939053litany
literacy1346803literacy
lunacy1136843lunacy
maraca10314153maraca
mercy125916183mer_cy
milady1236613milady
mincy125817413mi_ncy
miracle1138843miracle
mirage92313653mirage
mirky146315523mir_ky
miry96326753mir__y
misact10316693misact
moray105423793mora_y
orach105219233_orach
pac79054083p__ac_
paca85132243p__aca
pace86345773p__ace
pacey126720283p__acey
pack125535443p__ack
pacs85842183p__acs
pact86648723p__act
palace104516923palace
paly95835533p__aly
para65242173para__
parade94720643parade
parae76335703para_e
paramo102614643paramo
parang93715513parang
paraph13311263paraph
paras76143043para_s
parch125123003par_ch
pardy115523953par_dy
parity114719873parity
parlay113713993parlay
parley116718363parley
parody12410093parody
parry105323753par_ry
partly116315473partly
party106630613par_ty
pataca10311193pataca
paty95234563p__aty
pay88461183p__a_y
peace95026083p_eace
peach125422493p_each
peachy164510843p_eachy
peaky145718153p_eaky
pearly116414843pearly
peaty105725693p_eaty
peavy135014843p_eavy
peracid12312993peracid
perch124518833per_ch
perdy115417333per_dy
perky145319483per_ky
peroxy1838253peroxy
perry105222713per_ry
pertly115312553pertly
pharmacy2043243pharmacy
phrase11109903phrase
phratry1543743phratry
pia56848033pi_a__
pial65636703pi_a_l
pian66136093pi_a_n
piano76118713pi_ano
pians75126963pi_ans
pias66542553pi_a_s
pibal95217323piba_l
pibals103813083pibals
pibroch1643803pibroch
pic76046823pi__c_
pica85831493pi__ca
picacho1644733picacho
pical95524373pica_l
picara10311903picara
picaro10311323picaro
picas94626523pica_s
pice84641093pi__ce
pick125933813pi__ck
picky165416943pi_cky
picrate112014143picrate
picric12309923picric_
pics85633913pi__cs
piddly13319143piddly
piece96717993pi_ece
pierce104010393pierce
piety105817303pi_ety
piggy124011433pi_ggy
pigmy13299433pi_gmy
pigsty1235933pigsty
pika106322953pika__
pikake11115803pikake
pikas114218093pika_s
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pila_r
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
pily96132733pi__ly
pima85428653pima__
pimas94725103pima_s
pimply15329213pimply
pina65842633pina__
pinang92611593pinang
pinas75434453pina_s
pinata83817223pinata
pinch125619303pi_nch
pinery115214293pinery
piney105727503pi_ney
pinkey154314673pinkey
pinkly155012243pinkly
pinky145823403pi_nky
pinnace113510313pinnace
pinny105222063pi_nny
piny911838353pi__ny
pipage1199143pipage
pipal95118353pipa_l
pipals104213643pipals
pipy115421513pi__py
piquancy2442973piquancy
piracies12312643piracies
piragua1044643piragua
piranas9912603piranas
piranha12126363piranha
pirarucu1251993pirarucu
pirated102515613pirated
pirates93020333pirates
piratic11314293piratic
pirayas1277483pirayas
pirn67128373pir__n
pirns76020093pir_ns
pirog83913673pir_og
pirogi9299013pirogi
piscary1437423piscary
pisco96314983pi_sco
pita65436433pita__
pitas77427673pita_s
pitaya1186603pitaya
pitch125018413pi_tch
pitchy16479673pitchy
pithy135614463pi_thy
pity96031933pi__ty
pixy166117763pi__xy
pizazz1554223pizazz
pizazzy1952243pizazzy
place94824613p_lace
plack135017843p_lack
platy105021663p_laty
play95928983p_la_y
pleach134211243pleach
pliancy1435593pliancy
poach124917863p_oach
poachy16388963p_oachy
policy133211513policy
pomace123111913pomace
porch125918623por_ch
porgy116916123por_gy
porky145019333por_ky
porny106020193por_ny
portly114713403portly
praam94815613p_raam
prahu105013973p_rahu
pram85733493p_ra_m
prams96125513p_rams
prance104318573p_rance
prang84820323p_rang
prank115019453p_rank
prao66229023p_ra_o
praos74923563p_raos
prase76128753p_rase
prat65952043p_ra_t
prate75135983p_rate
prats76333393p_rats
prau66529473p_ra_u
praus74621753p_raus
prawn105312433p_rawn
prays105022433p_rays
preach133613923preach
preachy17307313preachy
preact103220393preact
prelacy1437583prelacy
prerace11414123prerace
prexy174611583p_rexy
prey96228483p_r_ey
priapi1037923priapi
price93725413p_rice
pricey134412633pricey
prick134317503p_rick
pricky174210343pricky
primary1437703primary
primly13439623primly
prince104114763prince
priory114110263priory
prissy11347853prissy
privy13439833p_rivy
prosy106319253p_rosy
proxy175011013p_roxy
pry85728053p_r__y
purana8712933purana
purely114013633purely
purify14399153purify
purity114114913purity
purply13369053purply
pursy105016413pur_sy
purty105019403pur_ty
purvey14559573purvey
pyran10514473pyra_n
pyrans11411063pyrans
pyric123815073pyric_
race66746263__race
rack106234883__rack
ray66361993__ra_y
rerack122513163rerack
ricrac1037013ricrac_
ricracs1136363ricracs
serac75925203serac_
seracs84418573seracs
sirupy11377053sirupy
spacy125415623_spacy
spicy125417713spi__cy
spinach1435403spinach
spinachy1842793spinachy
spiracle1255803spiracle
spiraea9407983spiraea
spiral83715343spira_l
spirally1348023spirally
spirals93212513spirals
spirant9814293spirant
spiry105017353spir__y
spray106720063spra_y
sprucy13356323sprucy
strawy1210312823strawy
stray88525573stra_y
tirade7311693tirade
trace75829613_trace
track114823013_track
tract75635713_tract
tray77632593_tra_y
triac74116373triac_
triacs83913223triacs
turaco839453turaco
vibrancy1843883vibrancy
virago1046643virago
viral86419593vira_l
virally1339653virally
vivace1436553vivace
vivary1536983vivary
wirily123310783wirily
wiry106422833wir__y
wrack145413883_wrack
zincy195413513zi_ncy
ziram163912893zira_m
zirams17438643zirams

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.373479064.3
2DLD Change Limit1127163356.03318683.2
3Display Results3353350.0933602.2
 (SQL Overall)1786913356.49927495.2
 
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.