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

292 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
pinks11572938(None) 
dinks105927951dinks
finks125424221finks
ginks104319561ginks
inks86926501_inks
jinks165019331jinks
kinks84926081kinks
links96430191links
minks115829271minks
oinks94819911oinks
picks135226141picks
pinas75434451pinas
pines76048861pines
pings85830881pings
pink107039381pink_
pinko115618251pinko
pinkos125313871pinkos
pinky145823401pinky
pins65558451pin_s
pints75936221pints
plinks124913261plinks
prinks124315381prinks
punks114822681punks
rinks94827101rinks
sinks95529181sinks
winks125325431winks
ains46158882ain_s
banks115527902banks
bilks115117892bilks
binds86627472binds
bines76946792bines
bins66548252bin_s
bints76130182bints
birks114920302birks
bisks115416802bisks
blinks124613572blinks
boinks125211272boinks
bonks116326462bonks
brinks124616312brinks
bunks115125082bunks
chinks155817572chinks
cines75239682cines
clinks125815062clinks
conks115525702conks
dicks125824692dicks
dines66449152dines
dings76331402dings
dink97137802dink_
dinky135819372dinky
dinos65428062dinos
dins56652042din_s
dints67431312dints
dirks105619522dirks
disks105417472disks
drinks116810712drinks
dunks105621192dunks
finds95424822finds
fines86644262fines
finis86824262finis
fink117532122fink_
finos86226952finos
fins75849092fin_s
funks125318912funks
gink97129522gink_
gins55543952gin_s
gunks104517722gunks
hanks126226862hanks
hicks145322172hicks
hinds96721472hinds
hinky155618752hinky
hins76447992hin_s
hints87330622hints
honks125124522honks
hunks125321452hunks
ilks87218572_ilks
ink76433632_ink_
inky115321582_inky
inns46920932_inns
ins35945602_in_s
irks86220132_irks
jink156227202jink_
jinns126013842jinns
jins115635012jin_s
junks164815972junks
kicks104420082kicks
kinas95626912kinas
kinds106221822kinds
kines95039132kines
kings105825562kings
kink76034402kink_
kinky115816382kinky
kinos96626142kinos
kins85747912kin_s
kirks84915262kirks
konks84917112konks
licks115325392licks
lines57054572lines
lings67135772lings
link86943442link_
linky127622382linky
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
lunks94822452lunks
micks135525372micks
milks115020582milks
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
mink106636532mink_
minke115421762minke
minkes124618782minkes
mints76834042mints
minus75223932minus
mirks115122142mirks
monks116123392monks
nicks114920492nicks
nines55937342nines
oink85429342oink_
opines84820702opines
packs135528932packs
paiks114719852paiks
pains75138282pain_s
paints85921832paints
panes76148692panes
pangs84628662pangs
pans65855732pan_s
pants76536922pants
parks116134462parks
peaks114825622peaks
pecks135724432pecks
peeks115021112peeks
peins76128062pein_s
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
perks115325802perks
pianos84315932pianos
pians75126962pians
pias66542552pi_as
picas94626522picas
pick125933812pick_
picky165416942picky
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pignus937952pignus
pigs76634222pi_gs
pika106322952pi_ka
pikas114218092pikas
pike106335212pi_ke
pikes115031032pikes
piki106520562pi_ki
pikis115116392pikis
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pin57066722pin__
pina65842632pin_a
pinch125619302pinch
pine67755712pin_e
pined85935322pined
piney105727502piney
ping75943592pin_g
pingo87122712pingo
pingos95317672pingos
pinked134819882pinked
pinken124513282pinken
pinkens13419642pinkens
pinker125322442pinker
pinkers134118602pinkers
pinkest132812622pinkest
pinkey154314672pinkey
pinkeys16378212pinkeys
pinkie124414272pinkie
pinkies133818262pinkies
pinkish16279112pinkish
pinkly155012242pinkly
pinkoes135512312pinkoes
pinna75320182pinna
pinnas85315512pinnas
pinny105222062pinny
pinon76024532pinon
pinons86019942pinons
pinot78737292pinot
pinots85920272pinots
pint66963172pin_t
pinta75727052pinta
pintas85021392pintas
pinto75625752pinto
pintos86021292pintos
pinup9612882pinup
pinups1037412pinups
piny911838352pin_y
pions75826392pions
pious74621272pious
pipes96030142pipes
pips85837132pi_ps
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pitas77427672pitas
piths105817542piths
pits66348742pi_ts
pixes144323172pixes
planks124116752planks
plink115219122plink_
plonks124210422plonks
plunks124711162plunks
pocks135022962pocks
poinds93511142poinds
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
porks115124142porks
pranks124814722pranks
pricks144414262pricks
prink114719672prink_
prints84320102prints
pucks134322102pucks
punas74826752punas
pungs85422222pungs
punk105729972punk_
punka114515482punka
punkas123410672punkas
punky144419392punky
puns66641482pun_s
punts75828002punts
pyins105815862pyin_s
ranks95225732ranks
reinks105012152reinks
ricks115126132ricks
rinds64826142rinds
rings65029172rings
rink87736992rink_
rins46153192rin_s
risks94917062risks
sicks115127622sicks
silks94620682silks
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sink86640142sink_
sins46755272sin_s
sinus55523852sinus
skinks94511652skinks
slinks104315152slinks
spanks124514122spanks
spicks144814992spicks
spiks114117472spi_ks
spines85132032spines
spins75327982spin_s
spunks12349332spunks
stinks105616832stinks
swinks134610652swinks
tanks94624732tanks
thinks134613362thinks
ticks115823292ticks
tines54848422tines
tings65329202tings
tins45251302tin_s
tints56030922tints
uplinks13345612uplinks
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wanks126124482wanks
wicks144619362wicks
winds95425602winds
wines85546862wines
wings95727242wings
wink116435022wink_
winos84625042winos
wins75949172win_s
wonks124818342wonks
yanks125316572yanks
yins75335122yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zinky215314812zinky
zins135735002zin_s
zonks184815172zonks

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.313570897.8
2DLD Change Limit538002921.56334421.0
3Display Results2922920.0763842.1
 (SQL Overall)1786912921.95291542.5
 
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.