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

321 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
piny91183836(None) 
liny78141331liny
pily96132741pily
pin57066731pin_
pina65842641pina
pine67755721pine
piney105727501piney
ping75943601ping
pink107039391pink
pinky145823401pinky
pinny105222061pinny
pins65558461pins
pint66963181pint
pipy115421521pipy
pity96031941pity
pixy166117771pixy
pony96434051pony
puny95526991puny
spiny104921301spiny
tiny76134641tiny
viny106025961viny
winy107034331winy
ain37579102ain_
ains46158892ains
airy75734162airy
any68440492_any
aping87327232aping
awny105919302awny
bin56658652bin_
bind76234522bind
bine66650872bine
bins66548262bins
bint67355052bint
bony96732082bony
briny104719662briny
cine66242952cine
city95122632city
cony96537832cony
deny86027122deny
didy99121522didy
din46459472din_
dine55555342dine
ding66940962ding
dingy105721262dingy
dink97137812dink
dinky135819372dinky
dino56036762dino
dins56652052dins
dint56759062dint
fin66458042fin_
find87532612find
fine75147962fine
fink117532132fink
finny114716752finny
fino76034702fino
fins75849102fins
gin46055762gin_
gink97129532gink
ginny95314572ginny
gins55543962gins
hin67559572hin_
hind85529762hind
hinky155618752hinky
hinny115616672hinny
hins76448002hins
hint77455752hint
icy86322132_icy
in28150872_in_
inby95315662_inby
ink76433642_ink
inky115321582_inky
inly75622212_inly
inn36727442_inn
ins35945612_ins
ivy96317452_ivy
jin106443942jin_
jink156227212jink
jinn115420252jinn
jins115635022jins
jinx185516582jinx
jivy176213122jivy
kin76353982kin_
kina85632012kina
kind96128572kind
kine85643442kine
king95933672king
kink76034412kink
kinky115816392kinky
kino86233632kino
kins85747922kins
lily76730192lily
limy95727722limy
lin37967382lin_
lindy96918322lindy
line46965582line
liney87029632liney
ling57447972ling
lingy96925142lingy
link86943452link
linky127622382linky
linn46034602linn
lino46343382lino
lins47059062lins
lint416266242lint
linty87126562linty
luny77324132luny
many95731862many
meiny104015412meiny
mina65136932mina
mincy125817412mincy
mind75434392mind
mine67256182mine
mingy115520182mingy
mini65634572mini
mink106636542mink
minny104518662minny
mint66758072mint
minty106323902minty
minx137723362minx
miry96326762miry
mity95528222mity
mony96830012mony
nine45842182nine
ninny84514932ninny
nixy145714522nixy
oily77932262oily
oink85429352oink
opine77422462opine
oping86322412oping
pacy115328682pacy
pain65647242pain_
pains75138282pains
paint75443692paint
painty114714752painty
paly95835532paly
pan58466452pan_
pandy115021172pandy
pane64950292pane
pang75336302pang
pans65855732pans
pansy105717972pansy
pant66061262pant
panty105929302panty
paty95234562paty
pay88461182p_ay
pein65834942pein_
peins76128062peins
pen56558842pen_
pend75934532pend
penny105119452penny
pens65649642pens
pent66559072pent
peony105717562peony
phony136715442phony
pi48145372pi__
pia56848042pi_a
pial65636712pial
pian66136102pian
piano76118712piano
pians75126962pians
pias66542562pias
pic76046832pi_c
pica85831502pica
pice84641102pice
pick125933822pick
picky165416942picky
pics85633922pics
pie55457412pi_e
pied75035372pied
pier66035302pier
pies66949612pies
piety105817302piety
pig65744982pi_g
piggy124011432piggy
pigmy13299432pigmy
pigs76634232pigs
piing85218832piing
pika106322962pika
pike106335222pike
piki106520572piki
pile65649702pile
pili66130362pili
pill65339472pill
pima85428662pima
pimp106024912pimp
pinas75434452pinas
pinch125619302pinch
pined85935322pined
pinery115214292pinery
pines76048862pines
pingo87122712pingo
pings85830882pings
pinkey154314672pinkey
pinkly155012242pinkly
pinko115618252pinko
pinks115729382pinks
pinna75320182pinna
pinon76024532pinon
pinot78737292pinot
pinta75727052pinta
pinto75625752pinto
pints75936222pints
pinup9612882pinup
pinyin112710612pinyin
pinyon11459762pinyon
pion67235302pion
pions75826392pions
pip78051052pi_p
pipe86434442pipe
pips85837142pips
pirn67128382pirn
pirns76020092pirns
pis56362042pi_s
pish96127922pish
piso66727572piso
piss65033342piss
pit56471932pi_t
pita65436442pita
pith95432702pith
pithy135614462pithy
pits66348752pits
piu56639552pi_u
pix126437942pi_x
play95928982play
plink115219122plink
ploy96123602ploy
ply86323552p_ly
pogy105623552pogy
poind84217912poind
point75338732point
pointy114913282pointy
poky135922152poky
poly96235152poly
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
porny106020192porny
posy96028422posy
poxy166820892poxy
pray96331532pray
prey96228482prey
pricy124814562pricy
prink114719672prink
print74837462print
privy13439832privy
pry85728052p_ry
pun58846512pun_
puna65331652puna
pung75429632pung
punk105729972punk
punky144419392punky
punny104217712punny
puns66641482puns
punt65747202punt
punty106021612punty
pyin96823232pyin_
pyins105815862pyins
rainy85921082rainy
rimy96621292rimy
rin36663192rin_
rind56535612rind
rindy95717402rindy
ring56541162ring
rink87737002rink
rins46153202rins
shiny115122142shiny
sin36265902sin_
sine46560632sine
sing57544182sing
sinh76238052sinh
sink86640152sink
sins46755282sins
sizy164816402sizy
spicy125417712spicy
spiky146014112spiky
spin66231302spin_
spine76534422spine
spinny114510182spinny
spins75327982spins
spiry105017352spiry
tidy86822432tidy
tin36362182tin_
tine45855142tine
ting56139922ting
tinny85317652tinny
tins45251312tins
tint46758872tint
tivy1014516872tivy
tony75635152tony
twiny116012812twiny
veiny115414362veiny
vina76331812vina
vine75643692vine
vino76128442vino
vinyl115311622vinyl
wany106432362wany
whiny144915572whiny
wily106428822wily
win66456302win_
wind85533862wind
windy126118112windy
wine74953432wine
winey115325432winey
wing86339232wing
wingy126521032wingy
wink116435032wink
wino75933622wino
wins75949182wins
wiry106422842wiry
yin67648742yin_
yins75335132yins
zany167316992zany
zin125643782zin_
zinc156819102zinc
zincy195413512zincy
zine137036162zine
zing145728622zing
zingy186516132zingy
zinky215314812zinky
zins135735012zins

Search took 3 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 Filter178691298720.576310227.4
2DLD Change Limit298723211.86016060.2
3Display Results3213210.1562057.7
 (SQL Overall)1786913212.59268939.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.