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

216 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
piney10572750(None) 
liney87029631liney
pine67755711pine_
pined85935321pined
pinery115214291pinery
pines76048861pines
pinkey154314671pinkey
pinky145823401pinky
pinny105222061pinny
piny911838351pin_y
winey115325431winey
bine66650862bine_
biner75930692biner
bines76946792bines
boney105227312boney
cine66242942cine_
cines75239682cines
coney105932882coney
dicey114819332dicey
dikey135116422dikey
dine55555332dine_
dined76431992dined
diner65632902diner
dines66449152dines
dingey114914052dingey
dingy105721262dingy
dinkey144812762dinkey
dinky135819372dinky
fine75147952fine_
fined94930502fined
finely123011562finely
finer85431562finer
finery124512892finery
fines86644262fines
finny114716752finny
ginny95314572ginny
hinky155618752hinky
hinny115616672hinny
honey115629912honey
inby95315662_inby
inky115321582_inky
inly75622212_inly
jitney16304622jitney
jivey185111872jivey
kidney1434762kidney
kine85643432kine_
kines95039132kines
kinky115816382kinky
limey104721042limey
lindy96918312lindy
line46965572line_
lined64934642lined
linen55728722linen
lineny94011442lineny
liner55938922liner
lines57054572lines
lingy96925142lingy
linky127622382linky
linsey938992linsey
linty87126562linty
liny78141322lin_y
mincy125817412mincy
mine67256172mine_
mined85333352mined
miner76933542miner
mines75651952mines
mingy115520182mingy
minny104518662minny
minty106323902minty
money104826842money
nine45842172nine_
nines55937342nines
ninety9510962ninety
ninny84514932ninny
opine77422462opine_
opined95113852opined
opines84820702opines
pacey126720282pacey
pained95622852pained
painty114714752painty
pandy115021172pandy
pane64950292pane_
paned85437182paned
panel76023622panel
panes76148692panes
pansy105717972pansy
panty105929302panty
peined94918842peined
penes75839222penes
penny105119452penny
phoney143612982phoney
pice84641092pice_
picky165416942picky
pie55457402pi_e_
pied75035362pi_ed
pier66035292pi_er
pies66949602pi_es
piety105817302piety
piggy124011432piggy
pigmy13299432pigmy
pigsney1342872pigsney
pike106335212pike_
piked125623312piked
piker115622842piker
pikes115031032pikes
pile65649692pile_
pilea75123952pilea
piled85232992piled
pilei74021782pilei
piles74742612piles
pily96132732pi_ly
pin57066722pin__
pina65842632pin_a
pinas75434452pinas
pincer104019172pincer
pinch125619302pinch
pinder94523452pinder
pineal84817682pineal
pinene82915642pinene
pineta85815562pineta
ping75943592pin_g
pinged104321382pinged
pinger94324092pinger
pingo87122712pingo
pings85830882pings
pinier84024692pinier
pink107039382pin_k
pinked134819882pinked
pinken124513282pinken
pinker125322442pinker
pinkeye16326492pinkeye
pinkeys16378212pinkeys
pinkly155012242pinkly
pinko115618252pinko
pinks115729382pinks
pinna75320182pinna
pinned94818382pinned
pinner84521502pinner
pinon76024532pinon
pinot78737292pinot
pins65558452pin_s
pint66963172pin_t
pinta75727052pinta
pinto75625752pinto
pints75936222pints
pinup9612882pinup
pipe86434432pipe_
piped105123162piped
piper96523192piper
pipes96030142pipes
pipet95533322pipet
pipy115421512pi_py
pithy135614462pithy
pity96031932pi_ty
pixel143911902pixel
pixes144323172pixes
pixy166117762pi_xy
pogey116017892pogey
pointy114913282pointy
pokey145318972pokey
pone65747532pone_
pones74547042pones
pony96434052pon_y
prey96228482p_rey
pricey134412632pricey
punkey154011172punkey
punky144419392punky
punny104217712punny
punty106021612punty
puny95526992pun_y
riley84420582riley
rindy95717392rindy
sine46560622sine_
sines55954822sines
sinew84718922sinew
sinewy12667512sinewy
spicey134414232spicey
spikey155411332spikey
spine76534422spine_
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spinney12438922spinney
spinny114510182spinny
spiny104921302spin_y
tine45855132tine_
tinea54923162tinea
tined65434532tined
tines54848422tines
tinny85317652tinny
tiny76134632tin_y
toney86027412toney
vine75643682vine_
vined95626152vined
vinery124912602vinery
vines85137642vines
viny106025952vin_y
waney115120322waney
whiney155012642whiney
wifey144913672wifey
wincey144110382wincey
windy126118102windy
wine74953422wine_
wined94434182wined
winery125014282winery
wines85546862wines
wingy126521032wingy
winy107034322win_y
witney12356842witney
zincy195413512zincy
zine137036152zine_
zineb165614142zineb
zines145232652zines
zingy186516132zingy
zinky215314812zinky

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 Limit538002161.58034050.6
3Display Results2162160.0464695.7
 (SQL Overall)1786912161.93992156.3
 
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.