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 “pinnae” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

520 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
pinnae8441464(None) 
pennae84314031pennae
pinna75320181pinna_
pinnace113510311pinnace
pinnal84814271pinnal
pinnas85315511pinnas
pinnate93613741pinnate
inane52820342_inane
innage73011572_innage
innate63917312_innate
jinnee13411572jinnee
minae75627722mi_nae
panne76623652pann_e
penna74520202penna_
penname11328552penname
pennate93314032pennate
penne75423852penn_e
pina65842632pi_na_
pinang92611592pinang
pinas75434452pi_nas
pine67755712pi_n_e
pineal84817682pineal
pinene82915642pinene
pinite8321242pinite
pinkie124414272pinkie
pinnaces12268862pinnaces
pinnacle12416962pinnacle
pinnated11338552pinnated
pinned94818382pinned
pinner84521492pinner
pinnies93318442pinnies
pinnulae1044182pinnulae
pinnule936002pinnule
pinny105222062pinn_y
pinole83218782pinole
pinta75727052pinta_
pintas85021392pintas
pintle83818262pintle
pinwale1257842pinwale
anna45529013_anna_
annal56520763_annal
annas55824883_annas
ansae55720973_ansae
antae56828293_antae
benne76521123benn_e
biennale1044093biennale
binal75323823bi_nal
binate8419773binate
bindle94516263bindle
bine66650853bi_n_e
binge85125513bi_nge
binnacle12325633binnacle
binned94414543binned
bipinnate1342763bipinnate
bonne75124713bonn_e
bonnie85314853bonnie
canna75919333canna_
cannas84518403cannas
cannie83819363cannie
cine66242943ci_n_e
cinque1736853cinque
cnidae978143cnidae
connate9315753connate
diene65720133dien_e
dinar66319893di_nar
dindle84417223dindle
dine55555333di_n_e
dinge75627303di_nge
dingle84317073dingle
dinned84317613dinned
dinner74217153dinner
donna66215033donna_
donnas75511323donnas
donne65520463donn_e
donnee74317063donnee
dunnage9175213dunnage
faunae95210373faunae
fiance11310743fiance
final83922033fi_nal
finale94116763finale
finance1238573finance
finca104714503finca_
fincas113512073fincas
fine75147953fi_n_e
finial92814183finial
finite9316823finite
finned104114603finned
finnier10319943finnier
finny114716753finn_y
gingal81010143gingal
ginned83813983ginned
ginner73915813ginner
ginnier8298973ginnier
ginny95314573ginn_y
henna84414043henna_
hennaed1135103hennaed
hennas94211803hennas
hinge95323443hi_nge
hinnied11348103hinnied
hinnies103615103hinnies
hinny115616673hinn_y
inaner62213533_inaner
inanes62519803_inanes
inbye10427053_inbye
incage93513623_incage
incase83615283_incase
indie63721463_indie
indue63516673_indue
infare9313083_infare
ingate73018233_ingate
ingle64120433_ingle
inhale9411513_inhale
inia45024693_inia_
inkle94515833_inkle
inlace82513043_inlace
inlay85214323_inlay
inmate82917353_inmate
inn36727433_inn__
innages82911303_innages
inned64118423_inned
inner54920623_inner
inns46920933_inn_s
insane6314883_insane
insnare748243_insnare
intake10510863_intake
inure54119053_inure
invade10157853_invade
invar839513_invar
jingal1498583jingal
jingle143815223jingle
jinn115420243jinn__
jinni125310633jinn_i
jinnis13489053jinnis
jinns126013843jinn_s
kidnap1334193kidnap
kina85631993ki_na_
kinas95626913ki_nas
kinase104210653kinase
kindle114414233kindle
kine85643423ki_n_e
liana53915893liana_
lianas63713383lianas
liane54720663lian_e
librae84310173librae
lienal63912783lienal
lignan75510323lignan
linac7315413li_nac
linage7713403linage
lindane839023lindane
line46965573li_n_e
lineage878983lineage
lineal65616023lineal
linear65113333linear
lineate7815153lineate
linga66820813linga_
lingam95112333lingam
lingas75116563lingas
linguae8398393linguae
linkage1295963linkage
linn46034593linn__
linnet6419413linnet
linns56123333linn_s
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
mensae84114043mensae
mina65136903mi_na_
minas75434113mi_nas
mince95325233mi_nce
mine67256153mi_n_e
mingle93518783mingle
minke115421763mi_nke
minnies93617363minnies
minnow1135583minnow
minny104518663minn_y
mintage101110123mintage
minute83414293minute
minyan1138173minyan
misname11119483misname
nae35952743___nae
nannie63713223nannie
nine45842173ni_n_e
ninja1258093ninja_
ninjas1386303ninjas
ninnies73713613ninnies
ninny84514933ninn_y
opine77422463opi_n_e
padnag1036073padnag
paleae84820293paleae
pancake1536673pancake
panda85022613panda_
pandas95521963pandas
pane64950283p_an_e
panga85323533panga_
pangas99921103pangas
panned94123433panned
panner84224763panner
pannes85522853pannes
pannier93613353pannier
pantie84326473pantie
parae76335703p_arae
patinae95414403patinae
pavane114113443pavane
pawnage1335873pawnage
pawnee113115403pawnee
penal75228373p_enal
penance11313443penance
penang92511113penang
pence94924453p_ence
penial84120893penial
penile82219603penile
penman10312323penman
pennames12287783pennames
pennant9312493pennant
pennated11299543pennated
penned94217613penned
penner84616663penner
penni74617903penn_i
pennia84412973pennia
pennies94218813pennies
pennine93712953pennine
pennis84315743pennis
pennon8310643pennon
penny105119453penn_y
pensee8417313pensee
pentad9313763pentad
pentane9415743pentane
peonage1048723peonage
petnap1037423petnap
phenate12412193phenate
phonal11310383phonal
phonate12411813phonate
phone105621933phon_e
phylae14458733phylae
pia56848033pi__a_
piaffe1494913piaffe
pial65636703pi__al
pian66136093pi__an
pianic103714123pianic
piano76118713pian_o
pianos84315933pianos
pians75126963pian_s
pias66542553pi__as
piazze1634683piazze
pibal95217323pi_bal
pica85831493pi_ca_
pical95524373pi_cal
picante11310523picante
picas94626523pi_cas
pice84641093pi__ce
pickax2135913pickax
pickaxe2244623pickaxe
pickle144215653pickle
picnic123410263picnic
picrate112014143picrate
piddle103514913piddle
pie55457403pi___e
piece96717993pi_ece
pierce104010393pierce
pieta75421753pieta_
pietas84516503pietas
piffle14418233piffle
piggie103210773piggie
pignus937953pignus
pignut9311573pignut
piing85218833piin_g
pika106322953pi_ka_
pikake11115803pikake
pikas114218093pi_kas
pike106335213pi__ke
pilaf103923483pi_laf
pilar75221503pi_lar
pilau73618523pi_lau
pilaw103913743pi_law
pile65649693pi__le
pilea75123953pilea_
pileate93815923pileate
pillage103412593pillage
pillar8314023pillar
pilose84514233pilose
pilule8411123pilule
pima85428653pi_ma_
pimas94725103pi_mas
pimple123512963pimple
pin57066723pi_n__
pinangs10267793pinangs
pinata83817213pinata
pinatas93711483pinatas
pinball1137933pinball
pinbone1138173pinbone
pincer104019173pincer
pinch125619303pi_nch
pinched153812453pinched
pincher143812713pincher
pinches144117933pinches
pinder94523453pinder
pineals93212843pineals
pined85935323pi_ned
pinenes93416673pinenes
pinery115214283pinery
pines76048863pi_nes
pinesap1164723pinesap
pineta85815563pineta
piney105727503pi_ney
ping75943593pi_n_g
pinged104321383pinged
pinger94324083pinger
pingo87122713pi_ngo
pingoes105116513pingoes
pingos95317673pingos
pings85830883pi_ngs
pinhead13347073pinhead
pinhole122010433pinhole
pinier84024693pinier
pining93726533pining
pinion83815893pinion
pinites9319533pinites
pink107039383pi_n_k
pinked134819883pinked
pinken124513283pinken
pinker125322443pinker
pinkey154314673pinkey
pinkeye16326493pinkeye
pinkies133818263pinkies
pinkly155012243pinkly
pinko115618253pi_nko
pinkoes135512313pinkoes
pinkos125313873pinkos
pinks115729383pi_nks
pinky145823403pi_nky
pinnacled14304503pinnacled
pinnacles13276043pinnacles
pinnately1443753pinnately
pinners93518593pinners
pinning103417853pinning
pinniped1343853pinniped
pinnula934913pinnula
pinnular1044433pinnular
pinnulate1145763pinnulate
pinnules1036463pinnules
pinocle1138143pinocle
pinoles93418703pinoles
pinon76024533pi_non
pinones94717063pinones
pinons86019943pinons
pinot78737293pi_not
pinots85920273pinots
pins65558453pi_n_s
pint66963173pi_n_t
pintada1096073pintada
pintado1096573pintado
pintail9311173pintail
pintano998993pintano
pintles94118723pintles
pinto75625753pi_nto
pintoes95117713pintoes
pintos86021293pintos
pints75936223pi_nts
pinup9612883pi_nup
pinups1037413pinups
pinwales1367963pinwales
pinweed1346933pinweed
piny911838353pi_n_y
pinyin112710613pinyin
pinyon11459763pinyon
pion67235293pion__
pioneer936883pioneer
pionic103515953pionic
pions75826393pion_s
pipage1199143pipage
pipal95118353pi_pal
pipe86434433pi__pe
pipeage1236203pipeage
pique16410173pi_que
pirana8713263pirana
piranas9912603piranas
pirate82322883pirate
pirn67128373pirn__
pirns76020093pirn_s
piscinae1285213piscinae
piste75824603pi_ste
pita65436433pi_ta_
pitas77427673pi_tas
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
pixie145415523pi_xie
pizza1538183pizza_
pizzas1646983pizzas
pizzaz1565443pizzaz
pizzle16279493pizzle
planar84212713planar
planate9314573planate
plane74929143plan_e
plena75816393plena_
plicae10410953plicae
plunge93811053plunge
pointe84619313pointe
ponce95222513p_once
pone65747533p_on_e
pongee94920193pongee
pounce105214093pounce
prance104318573prance
prename11412643prename
prince104114763prince
pronate9418873pronate
prone75332623pron_e
prune75119633prun_e
psoae74411623p_soae
puisne856353puisn_e
puna65331653p_una_
punas74826753p_unas
pungle94413573pungle
punka114515483punka_
punkah15347093punkah
punkas123410673punkas
punkie123513613punkie
punned93416193punned
punner84918153punner
punnet83518843punnet
punnier93511263punnier
punny104217713punn_y
pupae96515643p_upae
qindar16317173qindar
qintar15359143qintar
quinnat16116823quinnat
rennase738713rennase
rinse54820973ri_nse
senna54617983senna_
sennas64214233sennas
sienna647193sienna_
siennas736123siennas
signa66114703signa_
signage937773signage
signal73711483signal
signee73617233signee
silane62718053silane
silvae92811093silvae
since75024173si_nce
sine46560623si_n_e
singe65731133si_nge
single74520603single
sinkage1287263sinkage
sinned73818413sinned
sinner64320593sinner
sinuate7412153sinuate
spicae104313703spi_cae
spinage10289653spinage
spinal84915313spi_nal
spinate93114813spinate
spindle103210093spindle
spine76534423spi_n_e
spinnaker1542313spinnaker
spinner93912263spinner
spinney12438923spinney
spinnies103210543spinnies
spinny114510183spinn_y
spinose937943spinose
spinulae10276963spinulae
spinule9299993spinule
sundae7312873sundae
sunna55016063sunna_
sunnah9369353sunnah
sunnas63914563sunnas
tannage8209583tannage
tannate71813523tannate
teniae64517353teniae
tibiae838473tibiae
tincal83913353tincal
tine45855133ti_n_e
tinea54923153tinea_
tineal66216153tineal
tineas64616473tineas
tinge64626613ti_nge
tingle74319053tingle
tinkle103714453tinkle
tinman82411123tinman
tinned74317533tinned
tinner64119953tinner
tinnier72910133tinnier
tinny85317653tinn_y
tinware1038593tinware
tisane6311573tisane
tonnage8168053tonnage
tonne54921433tonn_e
tunnage8166373tunnage
ulnae55214573_ulnae
venae85920983_venae
villae95615383villae
vina76331803vi_na_
vinal85725813vi_nal
vinas85126343vi_nas
vinca105315163vinca_
vincas113912453vincas
vine75643683vi_n_e
vineal94814743vineal
vintage11128143vintage
vitae84217633vi_tae
vittae93910993vittae
wannabe1234533wannabe
wienie9229973wienie
wince105220883wi_nce
windage1237933windage
windle104617953windle
wine74953423wi_n_e
winkle133812833winkle
winnable13156983winnable
winned104017013winned
winner94219923winner
winnow1234593winnow
wintle94014603wintle
winze175014853wi_nze
yince105214253yi_nce
zincate1838533zincate
zine137036153zi_n_e
zingare1737133zingare
zinnia1536013zinnia
zinnias1635863zinnias
zonae145116443_zonae

Search took 9 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165208.11013898.4
3Display Results5205200.3261595.1
 (SQL Overall)1786915208.57620836.2
 
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.