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

266 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
plexal153683(None) 
ileal56118082ile_al
leal46043272_le_al
legal65715942_legal
paleal84716672pale_al
peal68648102p_e_al
pedal86022502p_edal
penal75228372p_enal
petal76526892p_etal
plagal948572plagal
plea66830602ple_a_
plead85818462ple_ad
pleas75627032ple_as
pleat74734472ple_at
pleiad947832pleiad
plena75816392plena_
pleonal937242pleonal
pleural956672pleural
plex137321372plex__
plexes155313532plexes
plexor1535252plexor
plexus15377282plexus
plical10411682plical
plural839822plural
acetal84314903acetal
adnexal1543823adnexal
alegar739283alegar
alexia132910463alexia
alexias14249793alexias
alexin132311483alexin
algal66518213al_gal
apneal83411123apne_al
appeal103911613appe_al
apteral9311523apteral
areal55928733are_al
asexual1443973asexual
axal116520493__axal
biaxal1536093biaxal
bleak115915383ble_ak
blear75918683ble_ar
bleat75737003ble_at
caecal103713733caecal
cecal94619113_cecal
clean75420413cle_an
clear76219053cle_ar
cleat76335063cle_at
clinal8311553clinal
clonal8310913clonal
coaxal15387303coaxal
coeval1138893coeval
coxal146116673_coxal
credal9311673credal
daedal849083daedal
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
egal55119433__egal
exalt123018533__exalt
exam132514623__exam
faecal11359813faecal
feal713940423_fe_al
fecal105119213_fecal
feral85424653_feral
fetal85623373_fetal
flea75628493fle_a_
fleam106017283fle_am
fleas86423663fle_as
flex146123473flex__
flexed17419083flexed
flexes164512953flexes
flexile1735073flexile
flexor1634503flexor
flexural1842443flexural
floral94313813floral
foetal9311883foetal
gleam86916733gle_am
glean65818203gle_an
gleba83910243gleba_
glebae9407613glebae
glial66715433gl_ial
global937663global
haemal113811643haemal
heal75645693_he_al
hemal104419803_hemal
hexad164910623_hexad
hexyl1844463_hexyl
hiemal11339493hiemal
hyetal1236543hyetal
ideal65716393ide_al
ilea45931463ile_a_
ileac75814173ile_ac
ilex115822033ilex__
ilexes134510253ilexes
ilial55317833il_ial
illegal854763illegal
lea37660183_le_a_
lead56038853_le_ad
leaf76441033_le_af
leak86233713_le_ak
lean46345243_le_an
leap66032683_le_ap
lear47045953_le_ar
leas45954183_le_as
legals73412733_legals
leman75622603_leman
lethal939803_lethal
leva77020713_leva_
level84116553_level
lex107943823_lex__
lexes127225263_lexes
lexical1637363_lexical
lexis125916033_lexis
lienal63912783lienal
local74820273_local
loral55927823_loral
loyal84513483_loyal
meal65643173_me_al
medal86221323_medal
metal75427383_metal
olea46532723ole_a_
paean77222723pae_an
paella8410913paella
paesan85114093paesan
pal56761673p___al
palatal9310153palatal
palea75028663pale_a_
paleae84820293pale_ae
pallial92911253pallial
palpal104112053palpal
paludal1035683paludal
papal95820673p_apal
parral85517533parral
pascal10812373pascal
pausal81511963pausal
pea56657243p_e_a_
peag75431343p_e_ag
peak106535203p_e_ak
peals75235493p_e_als
pean66147173p_e_an
pear69745233p_e_ar
pearl75324463p_earl
peas65755063p_e_as
peat65967933p_e_at
pecan91919033p_ecan
pedalo93811143p_edalo
pedals94316033p_edals
peel65535613p_e_el
peepul1035783peepul
pekan111613973p_ekan
pelletal1045723pelletal
penial84120893penial
pepla9312863p_epla
peril75425953p_eril
petals84719813p_etals
phenol1149253phenol
phenyl1435323phenyl
phial10313203p_hial
phonal11310383phonal
pial65636703p__ial
pibal95217323p_ibal
pical95524373p_ical
piebald1245503piebald
pieta75421753pieta_
pietas84516503pietas
pilea75123953pile_a_
pineal84817683pineal
pinnal84814273pinnal
pipal95118353p_ipal
pixel143911903p_ixel
plan65833943pl__an
planar84212713planar
plat66048873pl__at
platan83913693platan
play95928983pl__ay
playa105812943playa_
playas114612283playas
plaza164311063plaza_
plazas17409913plazas
pleach134211243pleach
pleads94613953pleads
please84315733please
pleats85218593pleats
pleb86123813ple__b
plebe95014873ple_be
plebes104313623plebes
plebs95814583ple_bs
pled75231433ple__d
pledge10469473pledge
pleiads1045223pleiads
plenary1237543plenary
plench134010813plench
plenty11311413plenty
plenum1039503plenum
pleon74216383ple_on
pleons84213343pleons
pleura837533pleura
pleurae945863pleurae
pleuras937413pleuras
plew97222813ple__w
plews105415353ple_ws
plexors1645423plexors
plica9613373plica_
plicae10410953plicae
plurals936913plurals
pluvial1245433pluvial
poleax1547993pole_ax
poleaxe1656303poleaxe
polecat11313143polecat
portal84218463portal
postal84317533postal
preanal9310713preanal
preaxial1746973preaxial
predial103815413predial
prefab1336243prefab
prefixal2044543prefixal
prelaw1139103prelaw
prelegal1145043prelegal
preman104117453preman
premeal11310513premeal
preoral9312673preoral
prepay13310313prepay
presa74319043presa_
presale9416353presale
pretax152310193pretax
prevail1238243prevail
prewar114712573prewar
prex135722973prex__
prexes154915943prexes
prexy174611573prex_y
primal104014623primal
puberal1147773puberal
pulpal10408453pulpal
pupal97616873p_upal
pyrexial20234963pyrexial
quezal2435143quezal
real45750293_re_al
regal65023793_regal
renal55929503_renal
scleral937863scleral
seal45654373_se_al
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sexual1338413_sexual
sheal84927703she_al
spheral1238423spheral
splenial1047183splenial
steal56125473ste_al
teal45546503_te_al
telial65815363telial
tepal76319583_tepal
texas126514933_texas
thecal113310303thecal
thenal92712413thenal
ulema7109713ulema_
ulemas888963ulemas
upleap10106843uple_ap
ureal56722683ure_al
uveal84411073uve_al
veal76936813_ve_al
venal85523213_venal
vexil1538963_vexil
weal75838683_we_al
wheal115716183whe_al
zeal135530333_ze_al
zoeal144813783zoe_al

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.296603685.8
2DLD Change Limit1127162668.06313979.4
3Display Results2662660.0932860.2
 (SQL Overall)1786912668.45221141.9
 
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.