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

272 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
pleura83753(None) 
pleurae945861pleurae
pleural956671pleural
pleuras937411pleuras
fleury12417352fleury
laura54116202_laura
parura8310582parura
plea66830602ple__a
plectra1145792plectra
plena75816392ple_na
pleuron976342pleuron
plural839822pl_ural
pneuma1035262pneuma
alegar739283alegar
alert54740653ale_rt
aleuron757383aleuron
alexia132910463alexia
algebra1043043algebra
allure63012943allure
alula5317093al_ula
aura45836253__aura
beluga936233beluga
blear75918683blear_
blears85116453blears
bleary115112553bleary
bluer74918493bluer_
blur66020533bl_ur_
blurb95214903bl_urb
blurs74619083bl_urs
blurt77625623bl_urt
bura66139533__bura
caesura956233caesura
cesura838763cesura
clear76219053clear_
clears84116563clears
clerk115812453cle_rk
clour76617283clour_
clours85215093clours
crura7312583_crura
datura738033datura
doura66518663_doura
dura55232113__dura
elytra934893elytra
ephedra1344213ephedra
era35741503__e_ra
euro45325273__euro
exedra1434503exedra
eyra76217553__eyra
feuar8310243_feuar
flauta937823flauta
flea75628493fle__a
fleer86020773fleer_
fleers96015793fleers
fleuron1055573fleuron
flexural1842443flexural
flexure1743413flexure
flora85317103fl_ora
flour84916453flour_
flours94414053flours
floury12449573floury
gleba83910243gle_ba
gluer65116773gluer_
gluers75011153gluers
ilea45931463ile__a
ileum74512823ileu_m
ileus54616893ileu_s
jura116024893__jura
labra75415463_labra
laurae64011663_laurae
lauras63414333_lauras
lea37660183_le__a
lear47045953_lear_
learn55322663_learn
lears55938733_lears
leary85927383_leary
leer46239353_leer_
leers54828983_leers
leery85919133_leery
lehr75514943_lehr_
lehrs86111133_lehrs
lehua837953_lehua
lemma94811033_lemma
lemur739773_lemur_
lemurs837253_lemurs
lepta75714393_lepta
leu36047403_leu__
leud57223423_leu_d
leuds66214813_leuds
leva77020713_le_va
libra74712423_libra
lira46928683_l_ira
louma76213633_louma
lour45430683_lour_
lours55125293_lours
loury85716753_loury
luma65527523_l_uma
luna46229853_l_una
lure45142463_l_ure
lurk86624163_l_urk
lycra10317973_lycra
mura65633303__mura
neural6311993_neural
olea46532723ole__a
olestra746173olestra
oleum73613323oleu_m
oleums8358783oleums
opera7313573ope_ra
osetra667423osetra
paella8410913paella
pakora1247283pakora
palabra1137193palabra
palea75028663pale__a
paler75436933pale_r_
palestra1045893palestra
palmyra1444143palmyra
palpebra1442683palpebra
pandura1037143pandura
papula103011113papula
para65242173p__ara
pareira937533pareira
paruras9310533paruras
parure8312523parure
pea56657243p_e__a
pear69745233p_ear_
pearl75324463p_earl
pears75138613p_ears
peart76440753p_eart
pedro8313153p_edro
peer66238353p_eer_
peers75130273p_eers
peery105719443p_eery
peloria9310953peloria
pelota8612833pelota
peltry11288653peltry
penna74520203p_enna
penury1148103penury
pepla9312863p_epla
per56353093p_e_r_
pere66450263p_e_re
perea75026443p_erea
peri65636973p_e_ri
perk106232843p_e_rk
perm85834633p_e_rm
perp89029893p_e_rp
perry105222713p_erry
pert66759323p_e_rt
perv97224813p_e_rv
picara10311903picara
pier66035293pie_r_
piers75926333pie_rs
pieta75421753pie_ta
pilea75123953pile__a
pileum10399513pileu_m
pileup10437923pileu_p
pileups11365433pileups
pileus84514943pileu_s
planar84212713planar
planula935773planula
plasma103810913plasma
playa105812943pl_aya
plaza164311063pl_aza
pleach134211243pleach
plead85818463ple_ad
pleads94613953pleads
pleas75627033ple_as
please84315733please
pleasure1045543pleasure
pleat74734473ple_at
pleats85218593pleats
pleb86123813ple__b
plebe95014873ple_be
plebes104313623plebes
plebs95814583ple_bs
pled75231433ple__d
pledge10469493pledge
pleiad947833pleiad
plenary1237543plenary
plench134010813plench
plenty11311413plenty
plenum1039503plenum
plenums1136533plenums
pleon74216383ple_on
pleonal937243pleonal
pleons84213343pleons
plethora1344823plethora
pleurisy1343663pleurisy
plew97222813ple__w
plews105415353ple_ws
plex137321373ple__x
plexal1536843plexal
plexes155313543plexes
plexor1535253plexor
plexors1645423plexors
plexus15377283plexus
plica9613373pl_ica
plier75221283plier_
pliers84715153pliers
plough12577563plough
pluck134212303pl_uck
plug74915993pl_u_g
plugs85213493pl_ugs
plum85122103pl_u_m
plumb114514073pl_umb
plume94819463pl_ume
plump115315263pl_ump
plums94619953pl_ums
plumy124213233pl_umy
plunk114514403pl_unk
plurals936913pl_urals
plus66324833pl_u_s
plush105614713pl_ush
plyer106214333plyer_
plyers114912983plyers
pneumas1145103pneumas
poetry1139383poetry
polenta9310093polenta
poler74431793pole_r_
polers84225643pole_rs
polyuria1355823polyuria
poseur8419403poseur_
poseurs9378303poseurs
pour611527473p_our_
pours74623183p_ours
prearm104512353prearm
precure11312553precure
predry1237873predry
preoral9312673preoral
prepupa1064023prepupa
presa74319043pre_sa
prewar114712583prewar
prewrap14104973prewrap
pruta7314243p_ruta
pseud867043pseu_d
pseudo934713pseudo
pseuds944793pseuds
puja135714923p__uja
pula65129373p__ula
puler74826623pule_r_
pulers83820283pule_rs
puma85424123p__uma
puna65331653p__una
pupa85422813p__upa
pur56840553p__ur_
purda82914693p__urda
pure65543333p__ure
puri65931443p__uri
purl65631423p__url
purpura1144793purpura
purr64925813p__urr
purs65641043p__urs
pyemia1337553pyemia
pyuria1136953p_yuria
sclera838893scle_ra
sera46141393_se_ra
sierra637313sierra
sieur5911893sieur_
sieurs659043sieurs
sleuth937233sleuth
slur45525153sl_ur_
slurb74116323sl_urb
slurp74014983sl_urp
slurs54123373sl_urs
splenia948313splenia
sura45740293__sura
synura935983synura
terra54419663_terra
tetra53417953_tetra
ulema7109713ule_ma
ultra539363ul_tra
velure939773velure
vera76828843_ve_ra
zebra1637883_zebra

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 Limit1127162725.39320900.4
3Display Results2722720.0763578.9
 (SQL Overall)1786912725.84230587.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.