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

421 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
pineals9321284(None) 
pineal84817681pineal_
anneals7449942anneals
cineols9128852cineols
finals94316162fin_als
finials103210152finials
gingals9109312gingals
ideals75012502_ideals
jingals1588072jingals
lineal65616022lineal_
minerals10311372minerals
panels84716522pane_ls
peals75235492p__eals
pibals103813082pi_bals
pinas75434452pin_a_s
pinball1137932pinball
pinballs1246932pinballs
pinenes93416672pinenes
pines76048862pine__s
pinesaps1253982pinesaps
pinheads14336242pinheads
pinnal84814272pinnal_
pinnas85315512pinna_s
pintails10310162pintails
pintas85021392pinta_s
pinwale1257842pinwale
pinwales1367962pinwales
pipals104213642pi_pals
pixels15478532pixe_ls
spinals93911862spin_als
spinels94512442spine_ls
tincals93610642tincals
tineal66216162tineal_
tineas64616482tinea_s
vinals94716482vin_als
vineal94814742vineal_
ainsells895403ainsells
anears63717183_anears
animals94111703animals
annals66415923_annals
anneal64812293anneal_
annuals7388193annuals
apicals1159923api_cals
apneal83411123apneal_
apneas83211383apnea_s
appeals11378673appeals
bimetals1246943bimetals
binal75323823bin_al_
biners85023633bine_rs
bines76946793bine__s
canals84421663can_als
cantals93919573cantals
centals94317053centals
cereals9313173cereals
cineast9310523cineast
cineasts1045543cineasts
cinemas1138043cinemas
cineol8108203cineol_
cineole91010003cineole
cineoles10109403cineoles
cines75239683cine__s
citrals91111673citrals
conceals123111013conceals
congeals11309853congeals
cuneal8611513cuneal_
deals65435343__deals
denials84114133denials
dentals83915393dentals
dials64925343di__als
dinars75417563din_ars
dineros83812333dineros
diners75525953dine_rs
dines66449153dine__s
dismals102010243dismals
dynels10536813dyne_ls
enneads834733enneads
epigeal1046243epigeal_
epinaos936283epin_aos
final83922033fin_al_
finale94116763fin_ale
finales104016013fin_ales
finalis103313663fin_alis
fincas113512073finca_s
fineable131810333fineable
finely123011563fine_ly
fines86644263fine__s
finial92814183finial_
fiscals1238003fiscals
funerals1146453funerals
fungals11276783fungals
generals9109333generals
gimbals12257823gimbals
gimels938893gime_ls
gimmals12225823gimmals
gingal81010153gingal_
gingall9117333gingall
gingalls1096433gingalls
guineas836753guinea_s
heals85733453__heals
ideal65716393_ideal_
ideas65919013_idea_s
ileal56118083_ileal_
indols74714203_indols
inerts64517023_inerts
infall939403_infall
infalls1038943_infalls
inhale9411513_inhale
inhales10511863_inhales
inhauls1035523_inhauls
inlays9389873_inlays
inseams9307903_inseams
instals7611713_instals
invars9310003_invars
inwall938343_inwall
inwalls1037283_inwalls
jingal1498593jingal_
jingall1566173jingall
jingalls1685333jingalls
jiveass1792163jiveass
kinas95626913kin_a_s
kinemas1336893kinemas
kines95039133kine__s
kineses113111253kineses
kinesis11259593kinesis
kneads11357093_kneads
kneels10408933_kneels
knells10439253_knells
libels85112693libe_ls
liberals1039413liberals
lienal63912783lienal_
linacs8310813lin_acs
lineable101811083lineable
lineage878983lineage
lineages979183lineages
lineally1137793lineally
linear65113343linea_r
linearly1146793linearly
lineate7815153lineate
linens64818393line_ns
liners65428853line_rs
lines57054573line__s
lineups934913lineups
lingams104510193lingams
lingas75116573linga_s
linguals9317223linguals
lintels73311163lintels
lintols7339553lintols
literals8312293literals
manuals9311213manuals
meals75933373__meals
menials94015683menials
micells11107683micells
minas75434113min_a_s
mineable121611053mineable
mineral9312733mineral_
miners84126633mine_rs
mines75651953mine__s
minimals12327433minimals
minyans1237263minyans
misdeals1147223misdeals
miseats92815783miseats
miskals13369763miskals
missals93914423missals
neaps75618323__neaps
nears55529423__nears
neats55931903__neats
nines55937343nine__s
ninjas1386303ninja_s
opines84820703opine__s
ordeals877993ordeals
paeans85118263p_aeans
paleal84716673paleal_
pals66951353p___als
pandas95521963panda_s
panel76023623pane_l_
panes76148693pane__s
panfuls1237173panfuls
pangas99921103panga_s
parrals94414573parrals
pascals11610013pascals
peags86122843p__eags
peaks114825623p__eaks
peal68648103p__eal_
peans75437643p__eans
pearls84715393p__earls
pears75138613p__ears
peas65755063p__ea_s
peats76140193p__eats
pedals94316033p_edals
peels75226423p__eels
penal75228373pen_al_
pencels113610053pencels
pencils113011773pencils
penes75839223pene__s
penial84120893penial_
pensils92811593pensils
pentads1039523pentads
pentyls1236523pentyls
perineal1049193perineal_
petals84719813p_etals
phenols1238103phenols
phenyls1534333phenyls
phials1158873p_hials
phreaks1634543phreaks
pial65636703pi__al_
pians75126963pi__ans
pias66542553pi__a_s
pibal95217323pi_bal_
pical95524373pi_cal_
picas94626523pi_ca_s
piceous11310693piceous
piculs103511753pi_culs
piebald1245503piebald
piebalds1344343piebalds
pieces104217273pi_eces
piers75926333pi_e_rs
pies66949603pi_e__s
pietas84516503pi_etas
pigeons1039183pigeons
pigtails1146033pigtails
pikas114218093pi_ka_s
pikers124717393pike_rs
pikes115031033pike__s
pilafs113511023pi_lafs
pilaus84114133pi_laus
pilaws11399433pi_laws
pilea75123953pilea__
pileate93815923pileate
pileous9510523pileous
piles74742613pile__s
pileups11365433pileups
pileus84514943pile_us
pillars9313493pillars
pills74130973pi__lls
pimas94725103pi_ma_s
pina65842633pin_a__
pinang92611593pin_ang
pinangs10267793pinangs
pinata83817223pin_ata
pinatas93711503pinatas
pincers113916503pincers
pinches144117933pinches
pinders103720473pinders
pine67755713pine___
pineapple1241773pineapple
pineapples1351803pineapples
pined85935323pine__d
pineland1145893pineland
pinelands1244933pinelands
pinene82915643pine_ne
pineries102419083pineries
pinery115214293pine_ry
pinesap1164723pinesap
pineta85815563pine_ta
pinetum1145553pinetum
piney105727503pine__y
pinfold1336233pinfold
pinfolds1445143pinfolds
pingers104020743pingers
pingoes105116523pingoes
pingos95317673pin_gos
pingrass1146003pingrass
pings85830883pin__gs
pinhead13347073pinhea_d
pinhole122010433pinhole
pinholes131810663pinholes
pinions93413603pinions
pinites9319533pinites
pinitols1046103pinitols
pinkens13419643pinkens
pinkers134118603pinkers
pinkeyes17335973pinkeyes
pinkeys16378213pinkeys
pinkies133818263pinkies
pinkly155012243pin_kly
pinkoes135512313pinkoes
pinkos125313873pin_kos
pinks115729383pin__ks
pinna75320183pinna__
pinnace113510313pinnace
pinnaces12268863pinnaces
pinnacle12416963pinnacle
pinnacles13276043pinnacles
pinnae84414643pinna_e
pinnate93613743pinnate
pinners93518603pinners
pinnies93318443pinnies
pinnula934913pinnula
pinnule936003pinnule
pinnules1036463pinnules
pinocle1138143pinocle
pinocles1248693pinocles
pinole83218783pin_ole
pinoles93418703pinoles
pinones94717073pinones
pinons86019943pin_ons
pinots85920273pin_ots
pins65558453pin___s
pinta75727053pinta__
pintada1096083pintada
pintadas11105083pintadas
pintado1096573pintado
pintados11105993pintados
pintail9311183pintail
pintano998993pintano
pintanos10107553pintanos
pintle83818263pin_tle
pintles94118723pintles
pintoes95117713pintoes
pintos86021293pin_tos
pints75936223pin__ts
pinups1037413pin_ups
pinweeds1454143pinweeds
pinwheels1742313pinwheels
pinyons12299003pinyons
pioneers1035863pioneers
pipal95118353pi_pal_
pipeage1236203pipeage
pipeages1336423pipeages
pipefuls1543753pipefuls
pipers104318663pipe_rs
pipes96030143pipe__s
pipets105714773pipe_ts
pistils93314303pistils
pistols93213983pistols
pitas77427673pi_ta_s
piteous9310683piteous
pitfall1245823pitfall
pitfalls1345373pitfalls
pitheads14338143pitheads
pitmans11188743pitmans
pitsaws1234993pitsaws
pittas86014523pitta_s
pixel143911903pixe_l_
pixes144323173pixe__s
pizzas1646983pizza_s
pleads94613953p_leads
pleas75627033p_lea_s
pleats85218593p_leats
plurals936913plurals
pones74547043pone__s
pontils9312213pontils
portals94015563portals
postals93716373postals
poundals1145013poundals
punas74826753pun_a_s
punkahs16284783punkahs
punkas123410673punka_s
qindars17267423qindars
qintars16268573qintars
quinelas1744933quinelas
quintals17288003quintals
reals55038653__reals
renewals1137273renewals
rentals74017473rentals
repeals94014523repeals
reseals73917663reseals
reveals103812723reveals
rials55026673ri__als
riels55121333ri_e_ls
ringhals1256263ringhals
rituals738353rituals
rivals94213183ri_vals
riyals94111083ri_yals
sandals82715203sandals
seals54839693__seals
sendals81912263sendals
sheals94420643_sheals
sials54227243si__als
signals8359163signals
simnels976103simne_ls
sines55954823sine__s
sinews94210623sine_ws
sisals63013573si_sals
sneaks104312493_sneaks
sneaps84510863_sneaps
snells64614203_snells
spiels85317953spi_e_ls
spinal84915313spin_al_
spinel85317333spine_l_
spinelle1046223spinelle
spinelles1146083spinelles
spines85132033spine__s
spinets94714813spine_ts
spirals93212513spi_rals
spireas94412513spirea_s
spitals93011593spi_tals
springals1245373springals
squeals1636513squeals
steals64020063_steals
teals56234133__teals
ticals83214713ti_cals
timbals11239533timbals
tincal83913363tincal_
tinea54923163tinea__
tineids8337873tineids
tines54848423tine__s
tinfuls1036593tinfuls
tinsels738373tinsels
unseals73212573unseals
urinals7610253urin_als
usneas638333usnea_s
vandals113211663vandals
veals84926193__veals
vials85822383vi__als
vinal85725813vin_al_
vinas85126343vin_a_s
vincas113912453vinca_s
vinegars1245063vinegars
vines85137643vine__s
vinyls12467003vin_yls
visuals1036853visuals
vitals94514303vi_tals
weals85428743__weals
wheals124512523_wheals
wines85546863wine__s
winesaps1364553winesaps
wiseass1035823wiseass
zeals145320853__zeals
zinebs17606803zine_bs
zines145232653zine__s

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340274216.20321606.8
3Display Results4214210.1403007.1
 (SQL Overall)1786914216.76326421.9
 
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.