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

183 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
pinier8402469(None) 
linier64423781linier
panier84425501panier
pincer104019171pincer
pinder94523451pinder
pinger94324081pinger
pinker125322441pinker
pinner84521491pinner
pipier104913981pipier
pitier84019821pitier
punier84519221punier
spinier93715161spinier
tinier63622231tinier
vinier93716741vinier
winier94522451winier
airier64619362airier
binder94422872binder
biner75930692bin_er
binger94923442binger
bonier84321992bonier
brinier93613462brinier
cinder94119122cinder
denier74420692denier
dicier94416232dicier
diner65632902din_er
dinger85323662dinger
dingier93513662dingier
dinkier123411502dinkier
dinner74217152dinner
finder104020232finder
finer85431562fin_er
finger104920322finger
finnier10319942finnier
ginger84920022ginger
ginner73915812ginner
ginnier8298972ginnier
hinder104120062hinder
hinger104723312hinger
hinkier143610792hinkier
hinter94021302hinter
icier74313742_icier
infer84215032_infer
inker94421092_inker
inkier104013772_inkier
inlier63615352_inlier
inner54920622_inner
inter55028492_inter
jinker174013542jinker
jivier16438612jivier
kinder113716842kinder
kinkier10319432kinkier
limier83518712limier
liner55938912lin_er
linger75225992linger
lingier84113372lingier
linker104321462linker
linter64625332linter
lintier73613792lintier
livier97514592livier
lunier64617602lunier
mincer104017362mincer
mincier113512462mincier
minder94822502minder
miner76933542min_er
mingier103815282mingier
miniver1238392miniver
minter84425102minter
mintier93615992mintier
mirier83918352mirier
mitier83620662mitier
oilier64417232oilier
pacier105018682pacier
painter93814562painter
paintier1048792paintier
palier85023562palier
pander93725522pander
paniers94717332paniers
panner84224762panner
pannier93613352pannier
panzer174213232panzer
penner84616662penner
phonier122710632phonier
picker144422172picker
pickier153912972pickier
piecer105213082piecer
pier66035292p__ier
piggier113510002piggier
piker115622842pi_ker
pilfer1139162pilfer
pincers113916502pincers
pincher143812712pincher
pinders103720472pinders
pine67755712pin_e_
pined85935322pin_ed
pinery115214282pin_ery
pines76048862pin_es
piney105727502pin_ey
pinged104321382pinged
pingers104020732pingers
piniest93121132piniest
pining93726532pining
pinion83815892pinion
pinite8321242pinite
pinites9319532pinites
pinked134819882pinked
pinken124513282pinken
pinkers134118602pinkers
pinkey154314672pinkey
pinkie124414272pinkie_
pinkies133818262pinkies
pinned94818382pinned
pinners93518592pinners
pinnies93318442pinnies
pioneer936882pioneer
piper96523192pi_per
pisher114317752pisher
pisser84416382pisser
pithier123010292pithier
pitied94017252pitied
pitiers93812652pitiers
pities83828082pities
pixie145415522pixie_
pixies154915512pixies
plier75221282p_lier
plinker134010962plinker
pointer93814932pointer
pointier1038302pointier
pokier124914632pokier
ponder94521692ponder
ponied94920702ponied
ponies84833462ponies
pornier93413122pornier
poxier153812112poxier
pricier113313112pricier
prier75027762p_rier
prinker133412742prinker
printer93917302printer
privier122910452privier
punker123718822punker
punkier133512792punkier
punner84918152punner
punnier93511262punnier
punter84320022punter
rainier71614252rainier
ribier84414222ribier
rimier83916262rimier
ringer74526052ringer
rinser64317212rinser
shinier104113142shinier
singer74227302singer
sinker103620902sinker
sinner64320592sinner
sinter63625922sinter
sizier1514813392sizier
spicier115112462spicier
spikier13369982spikier
spinner93912262spinner
spirier93214072spirier
tidier73515112tidier
tinder73821802tinder
tinker103619922tinker
tinner64119952tinner
tinnier72910132tinnier
tinter63923642tinter
tonier65520712tonier
twinier1037312twinier
veinier10269582veinier
vizier184311022vizier
wanier93920682wanier
whinier134110632whinier
wilier93217072wilier
wincer115018192wincer
winder104025262winder
windier113412162windier
winger104125432winger
wingier113413272wingier
winker134220292winker
winner94219922winner
winter94222802winter
wirier94215552wirier
zanier154314712zanier
zinger163816692zinger
zingier17369482zingier

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.1431249587.4
2DLD Change Limit825511832.64031269.3
3Display Results1831830.0632904.8
 (SQL Overall)1786911832.84662786.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.