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

202 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
pinker12532244(None) 
inker94421091_inker
jinker174013541jinker
linker104321471linker
picker144422171picker
piker115622841pi_ker
pincer104019171pincer
pinder94523451pinder
pinger94324091pinger
pinier84024691pinier
pinked134819881pinked
pinken124513281pinken
pinkers134118601pinkers
pinkey154314671pinkey
pinner84521501pinner
plinker134010961plinker
prinker133412741prinker
punker123718821punker
sinker103620901sinker
tinker103619921tinker
winker134220291winker
banker124222732banker
bicker144819172bicker
biker116022562bi_ker
bilker124913442bilker
binder94422872binder
biner75930692bin_er
binger94923452binger
blinker134110212blinker
bunker124519372bunker
canker124422522canker
cinder94119122cinder
clinker133811662clinker
conker124721552conker
danker114319662danker
dicker134521402dicker
diker105524552di_ker
diner65632902din_er
dinger85323672dinger
dinked124818352dinked
dinkey144812762dinkey
dinkier123411502dinkier
dinner74217162dinner
drinker12349482drinker
dunker113616462dunker
finder104020232finder
finer85431562fin_er
finger104920332finger
finked144214622finked
funker133915762funker
ginger84920032ginger
ginner73915822ginner
hanker134622092hanker
hiker125119392hi_ker
hinder104120062hinder
hinger104723332hinger
hinkier143610792hinkier
hinter94021302hinter
honker134117462honker
hunker133917672hunker
icker114018442_icker
infer84215032_infer
inked104218522_inked
inkers104018832_inkers
inkier104013782_inkier
inner54920632_inner
inter55028492_inter
jinked184013142jinked
jinkers183511812jinkers
junker174213652junker
kicker114116182kicker
kinder113716842kinder
kinked104014752kinked
kinkier10319432kinkier
lanker104123002lanker
licker125222042licker
liker95627062li_ker
liner55938922lin_er
linger75226002linger
linier64423792linier
linked114518212linked
linkers114317712linkers
linter64625342linter
lunker104718342lunker
milker124814322milker
mincer104017362mincer
minder94822502minder
miner76933542min_er
minke115421762minke_
minkes124618782minkes
minter84425102minter
mirker123712692mirker
nicker123818702nicker
oinked114213282oinked
packer144223402packer
painter93814562painter
pander93725522pander
panier84425502panier
panner84224762panner
panzer174213232panzer
parker124121372parker
pecker144615362pecker
penner84616662penner
picked154421312picked
pickeer153710112pickeer
pickers153718092pickers
picket144924312picket
pickier153912972pickier
piecer105213082piecer
pier66035292pi__er
pike106335212pi_ke_
piked125623312pi_ked
pikers124717392pi_kers
pikes115031032pi_kes
pilfer1139162pilfer
pincers113916502pincers
pincher143812712pincher
pinders103720472pinders
pine67755712pin_e_
pined85935322pin_ed
pinery115214292pin_ery
pines76048862pin_es
piney105727502pin_ey
pinged104321382pinged
pingers104020742pingers
pink107039382pink__
pinkens13419642pinkens
pinkest132812622pinkest
pinkeye16326492pinkeye
pinkeys16378212pinkeys
pinkie124414272pinkie
pinkies133818262pinkies
pinkly155012242pinkly
pinko115618252pink_o
pinkoes135512312pinkoes
pinkos125313872pinkos
pinks115729382pink_s
pinky145823402pink_y
pinned94818382pinned
pinners93518602pinners
pioneer936892pioneer
piper96523192pi_per
pipier104913982pipier
pisher114317752pisher
pisser84416382pisser
pitier84019822pitier
plinked143910892plinked
plinkers14309392plinkers
plunker133910652plunker
pointer93814932pointer
poker115122882p_oker
ponder94521692ponder
porker124917542porker
pricker154013412pricker
prinked143412162prinked
prinkers143010382prinkers
printer93917302printer
pucker143817632pucker
punier84519222punier
punkers133714852punkers
punkey154011172punkey
punkier133512792punkier
punner84918152punner
punter84320022punter
ranker105021902ranker
ringer74526062ringer
rinser64317212rinser
risker105414492risker
sicker124023902sicker
siker95326032si_ker
singer74227312singer
sinkers113618542sinkers
sinner64320602sinner
sinter63625922sinter
skinker10319442skinker
spanker133612352spanker
spiker124315662spi_ker
spinier93715162spinier
spinner93912262spinner
stinker113313312stinker
tanker104521122tanker
thinker143610682thinker
ticker124321502ticker
tinder73821802tinder
tinier63622232tinier
tinkers113517142tinkers
tinkler113610542tinkler
tinner64119962tinner
tinter63923642tinter
vinier93716742vinier
wanker134219972wanker
wicker154518672wicker
wincer115018192wincer
winder104025262winder
winger104125442winger
winier94522452winier
winked144018602winked
winkers143517112winkers
winner94219932winner
winter94222802winter
yonker134110852yonker
zinger163816702zinger

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 Filter178691825510.343520965.0
2DLD Change Limit825512022.25036689.3
3Display Results2022020.0633206.3
 (SQL Overall)1786912022.65667278.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.