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

330 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
pleiad94783(None) 
plead85818461ple_ad
pleiads1045221pleiads
iliad64613462il_iad
lead56038852_le_ad
plaid85118302plai_d
plea66830602ple_a_
pleads94613952ple_ads
pleas75627032ple_as
pleat74734472ple_at
pled75231432ple__d
pleiades1145752pleiades
plena75816392plena_
plexal1536842plexal
plied85118592pl_ied
ahead96817053ahe_ad
alcid85817973alci_d
alegar739283alegar
alexia132910463alexia_
alexias14249803alexias
algid75415583algi_d
alias55834603al_ias
alidad838883alidad
allied74217153allied
bead75937923_be_ad
belied95022163belied
bleak115915383ble_ak
blear75918683ble_ar
bleat75737003ble_at
bled75729313ble__d
bleed85019803ble_ed
blend85317453ble_nd
blind86319323bl_ind
bread85523113bre_ad
celiac101910433celiac
clad76225823cl__ad
clean75420413cle_an
clear76219053cle_ar
cleat76335063cle_at
cleped115114123cleped
clerid9312413clerid
clewed1225113203clewed
colead94114643cole_ad
dead65434243_de_ad
delead84112343delead
dread74419023dre_ad
egad64215413__egad
elegiac1045453elegiac
felid94717173feli_d
flea75628493fle_a_
fleam106017283fle_am
fleas86423663fle_as
fled85429773fle__d
flexed17419093flexed
fleyed13408813fleyed
flied96519433fl_ied
fluid94013963flui_d
gelid74916983geli_d
glad65624013gl__ad
gleam86916733gle_am
glean65818203gle_an
gleba83910243gleba_
glebae9407613glebae
gled65631143gle__d
gleed75320573gle_ed
gleyed11478153gleyed
glia56423153gl_ia_
glial66715433gl_ial
glias64618493gl_ias
head87137173_he_ad
heliac111010893heliac
helipad1344723helipad
hexad164910623_hexad
ilea45931463ile_a_
ileac75814173ile_ac
ileal56118083ile_al
ilia46026823il_ia_
iliac75013493il_iac
iliads7448673il_iads
ilial55317843il_ial
implead12315823imple_ad
jehad1637683_jehad
knead10429663kne_ad
lad48165713_l__ad
laid56439153_lai_d
laird65417793_laird
lea37660183_le_a_
leads66028493_le_ads
leady95618603_le_ady
leaf76441033_le_af
leak86233713_le_ak
leal46043273_le_al
lean46345243_le_an
leap66032683_le_ap
lear47045953_le_ar
leas45954183_le_as
led46254563_le__d
legal65715943_legal
lei36846383_lei__
leis45739603_lei_s
leman75622603_leman
lend56233673_le_nd
leud57223423_le_ud
leva77020713_leva_
levied104111433_levied
lewd85716593_le_wd
liar47229693_l_iar
liard65418593_l_iard
lid47453533_l_i_d
lied55838103_l_ied
load56730603_l_oad
loid55531503_loi_d
maenad939413maenad
mead75531603_me_ad
mediad104313713mediad
menad85918983_menad
myriad1235913myriad
naiad6313403_naiad
olea46532723ole_a_
oleic7313333olei_c
olein5316003olei_n
oleine6313793oleine
oleins6313523oleins
oread64619603ore_ad
pad68057333p___ad
paean77222723pae_an
paesan85114093paesan
paid75737493p_ai_d
palea75028663pale_a_
paleae84820293pale_ae
paleal84716673pale_al
paled85538723pale__d
pallia83015603pallia_
pallial92911263pallial
pallid93915293palli_d
palsied102911303palsied
pariah114320593pariah
parian83223973parian
pavid115717003pavi_d
pea56657243p_e_a_
peag75431343p_e_ag
peak106535203p_e_ak
peal68648103p_e_al
pean66147173p_e_an
pear69745233p_e_ar
peas65755063p_e_as
peat65967933p_e_at
pecan91919033p_ecan
ped66751533p_e__d
pedal86022503p_edal
peed76239183p_e_ed
peeing94618083peeing
peeked134314583peeked
peeled94119713peeled
peened94318163peened
peeped113915393peeped
peered93819493peered
peeved124112893peeved
pein65834943p_ei_n
peined94918843p_eined
peins76128063p_eins
peise75825773p_eise
peised94817683p_eised
pekan111613973p_ekan
pelican1139433pelican
pelite84323003pelite
pelted94617763pelted
penal75228373p_enal
pend75934533p_e_nd
penial84120893penial
pentad9313763pentad
pereia85217983pereia_
period9314983period
pesade9311103p_esade
petal76526893p_etal
petard95013803p_etard
phial10313203p_hial
pia56848043p__ia_
pial65636713p__ial
pian66136103p__ian
pias66542563p__ias
piebald1245503piebald
pieced113912103pieced
pied75035373p__ied
pieing93917653pieing
pieta75421753pieta_
pietas84516503pietas
pilea75123953pile_a_
piled85232993pile__d
pilei74021783pilei__
pitied94017253pitied
placard1236783placard
placed114318003placed
placid114012543placid
plagal948573plagal
plaice10311553plaice
plaided11409643plaided
plaids94312443plaids
plain74823303plai_n
plained103812233plained
plains85019593plains
plaint85323203plaint
plait75631573plai_t
plaited103713893plaited
plaits83816473plaits
plan65833943pl__an
planar84212713planar
planed94420913planed
plat66048873pl__at
platan83913693platan
plated95225773plated
play95928983pl__ay
playa105812943playa_
playas114612283playas
played124815033played
plaza164311063plaza_
plazas17409913plazas
pleach134211243pleach
pleaded113511263pleaded
pleader103511763ple_ader
please84315733please
pleased103712073pleased
pleated103816633pleated
pleats85218593pleats
pleb86123813ple__b
plebe95014873ple_be
plebeian1243173plebeian
plebes104313623plebes
plebs95814583ple_bs
pledge10469493pledge
pledged12358633pledged
plenary1237543plenary
plench134010813plench
plenish1239943plenish
plenism11310113plenism
plenist9314333plenist
plenty11311413plenty
plenum1039503plenum
pleon74216383ple_on
pleonal937243pleonal
pleons84213343pleons
pleopod1244823pleopod
pleura837533pleura
pleurae945863pleurae
pleural956673pleural
pleuras937413pleuras
plew97222813ple__w
plews105415353ple_ws
plex137321373ple__x
plexes155313543plexes
plexor1535253plexor
plexus15377283plexus
pliant83918823pl_iant
plica9613373pl_ica
plicae10410953plicae
plical10411683plical
plie65127393pl_i_e
plier75221283pl_ier
pliers84715153pliers
plies74526513pl_ies
plink115219123pl_ink
plod76723273pl__od
ploidy1237483ploidy
plowed124213203plowed
ployed124310563ployed
plumed114412883plumed
plural839823plural
pluvial1245433pluvial
pluvian1245333pluvian
plying124312083plying
podia8415283podia_
poind84217913p_oind
poleax1547993pole_ax
polecat11313143polecat
poled84934843pole__d
poleis86018353polei_s
poleward1455943poleward
poniard1037583poniard
ponied94920703ponied
prebade12310283prebade
prebid113512843prebid
prebind123810643prebind
predial103815413predial
preed85128123pre_ed
prefab1336243prefab
prefade1339013prefade
prelaw1139103prelaw
preload1049813preload
premade12311443premade
preman104117453preman
premed114617763premed
prepaid12310133prepaid
prepay13310313prepay
presa74319043presa_
pretax152310193pretax
prewar114712583prewar
preyed125313203preyed
pried84426863p_ried
pseud867043pse_ud
puled84926523pule__d
pyemia1337553pyemia_
pyemias1436803pyemias
pyoid11513763pyoi_d
read55942533_re_ad
relaid75518443relaid
relied74926233relied
reload7413893reload
replead10399013reple_ad
sled55334373sle__d
sleigh10258203sleigh
slewed104815523slewed
slid55828993sl_i_d
sloid64619713sloi_d
splenia948313splenia_
splenial1047183splenial
spread9312533spre_ad
stead65520273ste_ad
teiid6312533_teiid
teind6213613_teind
telia55821143telia_
telial65815363telial
tread64821703tre_ad
triad65217723_triad
ulema7109713ulema_
ulemas888963ulemas
ulnad65611453ul_nad
unlead73312373unle_ad
upleap10106843uple_ap
upload9257783upl_oad
weird95111283_weird

Search took 6 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.373479064.3
2DLD Change Limit1127163304.79623502.1
3Display Results3303300.1103000.0
 (SQL Overall)1786913305.27933849.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.