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

164 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
pinky14582340(None) 
dinky135819371dinky
hinky155618751hinky
inky115321581_inky
kinky115816381kinky
linky127622381linky
picky165416941picky
piney105727501piney
pink107039381pink_
pinkey154314671pinkey
pinkly155012241pinkly
pinko115618251pinko
pinks115729381pinks
pinny105222061pinny
piny911838351pin_y
punky144419391punky
zinky215314811zinky
chinky185610542chinky
conky145818742conky
dicky154816242dicky
dingy105721262dingy
dink97137802dink_
dinkey144812762dinkey
dinkly144311082dinkly
dinks105927952dinks
fink117532122fink_
finks125424222finks
finny114716752finny
funky154315132funky
gink97129522gink_
ginks104319562ginks
ginny95314572ginny
gunky135514112gunky
hanky155418292hanky
hinny115616672hinny
honky156218522honky
hunky155417732hunky
icky136315752_icky
inby95315662_inby
ink76433632_ink_
inks86926502_inks
inly75622212_inly
jink156227202jink_
jinks165019332jinks
junky194513232junky
kicky135012332kicky
kink76034402kink_
kinks84926082kinks
lanky125517482lanky
lindy96918312lindy
liney87029632liney
lingy96925142lingy
link86943442link_
links96430192links
linty87126562linty
liny78141322lin_y
milky144014442milky
mincy125817412mincy
mingy115520182mingy
mink106636532mink_
minke115421762minke
minks115829272minks
minny104518662minny
minty106323902minty
mirky146315522mirky
ninny84514932ninny
oink85429342oink_
oinks94819912oinks
painty114714752painty
pandy115021172pandy
pansy105717972pansy
panty105929302panty
pawky173810152pawky
peaky145718152peaky
pecky165515092pecky
penny105119452penny
perky145319482perky
pesky145911562pesky
pick125933812pick_
picks135226142picks
piety105817302piety
piggy124011432piggy
pigmy13299432pigmy
pika106322952pi_ka
pike106335212pi_ke
piki106520562pi_ki
pily96132732pi_ly
pin57066722pin__
pina65842632pin_a
pinas75434452pinas
pinch125619302pinch
pine67755712pin_e
pined85935322pined
pinery115214292pinery
pines76048862pines
ping75943592pin_g
pingo87122712pingo
pings85830882pings
pinked134819882pinked
pinken124513282pinken
pinker125322442pinker
pinkeye16326492pinkeye
pinkeys16378212pinkeys
pinkie124414272pinkie
pinkos125313872pinkos
pinna75320182pinna
pinon76024532pinon
pinot78737292pinot
pins65558452pin_s
pint66963172pin_t
pinta75727052pinta
pinto75625752pinto
pints75936222pints
pinup9612882pinup
pipy115421512pi_py
pithy135614462pithy
pity96031932pi_ty
pixy166117762pi_xy
plink115219122plink_
plinks124913262plinks
plisky1533712plisky
plunky15377952plunky
pocky165314602pocky
pointy114913282pointy
poky135922152p_oky
pony96434052pon_y
porky145019332porky
pricky174210342pricky
prink114719672prink_
prinks124315382prinks
punk105729972punk_
punka114515482punka
punkey154011172punkey
punks114822682punks
punny104217712punny
punty106021612punty
puny95526992pun_y
rindy95717392rindy
rink87736992rink_
rinks94827102rinks
risky126311522risky
silky125315822silky
sink86640142sink_
sinks95529182sinks
slinky13399102slinky
spiky146014112spi_ky
spinny114510182spinny
spiny104921302spin_y
spunky15427162spunky
stinky134611072stinky
tinkly134811152tinkly
tinny85317652tinny
tiny76134632tin_y
viny106025952vin_y
windy126118102windy
winey115325432winey
wingy126521032wingy
wink116435022wink_
winks125325432winks
winy107034322win_y
wonky154011772wonky
zincky24404962zincky
zincy195413512zincy
zingy186516132zingy

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001641.48336277.8
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.82597912.9
 
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.