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

399 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
pleach13421124(None) 
bleach133611401bleach
leach105422521_leach
peach125422491p_each
plench134010811plench
preach133613921preach
beach124623892_beach
blench133710452blench
breach134213722breach
clach124617822cl_ach
clench133910052clench
each95530582__each
fleech14367342fleech
flench144010812flench
fletch14388192fletch
ileac75814172ileac_
leachy14419732_leachy
leash85519212_leash
lech96825442_le_ch
leech104913212_leech
letch105215802_letch
loach105116362_loach
peace95026082p_eace
peachy164510842p_eachy
pech116125452p_e_ch
perch124518832p_erch
place94824612pl_ace
plack135017842pl_ack
planch133711442planch
plash104616562pl_ash
plea66830602plea__
pleached16338062pleached
pleaches153210432pleaches
plead85818462plea_d
pleads94613952pleads
pleas75627032plea_s
please84315732please
pleat74734472plea_t
pleats85218592pleats
poach124917862p_oach
preachy17307312preachy
preact103220392preact
reach105123882_reach
teach105221122_teach
upreach1444692upreach
alack114820063al_ack
alec66430063ale_c_
alecs76620733ale_cs
aleph10311393ale_ph
almah106917253alma_h
alpaca1047383alpaca
attach11118393attach
bach116131393__bach
beachy164011253_beachy
beech124315503_beech
belch124415503_belch
bench125619503_bench
black134719073bl_ack
blah98625063bl_a_h
blanch133410853blanch
bleached16378563bleached
bleacher15358883bleacher
bleaches153410673bleaches
bleak115915383blea_k
bleaks125112433bleaks
blear75918683blea_r
blears85116453blears
bleary115112553bleary
bleat75737003blea_t
bleats85518613bleats
blotch13197143blotch
brach126123303_brach
breath113916263breath
breech13348263breech
broach133611113broach
clachs133511323cl_achs
clack134720173cl_ack
clash106219033cl_ash
clean75420413clea_n
cleans85817053cleans
clear76219053clea_r
clears84116563clears
cleat76335063clea_t
cleats84919313cleats
cleave114212513cleave
clinch133910353clinch
cloaca1037263cloaca
clutch13367753clutch
coach125919453_coach
deash95617243_deash
death94822523_death
detach12310413detach
dreich12377723dreich
drench12369593drench
eath75735663__eath
elect74327033ele_ct
elenchi1244713elenchi
etch95419143__etch
fetch134913473_fetch
flack144519413fl_ack
flash115716213fl_ash
flea75628493flea__
fleam106017283flea_m
fleams115011943fleams
fleas86423663flea_s
fleche14299303fle_che
fleck148213593fle_ck
fleece11369903fleece
fleecy14266483fleecy
flesh115013743fle_sh
flinch144010103flinch
flitch14928173flitch
flysch1732893flysch
french143511213french
glace87420153gl_ace
gleam86916733glea_m
gleams94812253gleams
gleamy12398113gleamy
glean65818203glea_n
gleans75014743gleans
glitch12286353glitch
glunch1255353glunch
heath115724283_heath
heuch135312333_heuch
ilea45931463ilea__
ileal56118083ilea_l
iliac75013493iliac_
impeach1644273impeach
kench145513923_kench
ketch144912023_ketch
klatch15445933klatch
kvetch1832993kvetch
lac510155823_l_ac_
lace66848473_l_ace
lack105837683_l_ack
lacs66942483_l_acs
lacy95829633_l_acy
laich105920713_laich
lakh114919953_l_akh
larch105919793_larch
lash76539653_l_ash
latch104620463_latch
lath76640383_l_ath
lea37660183_lea__
leached133715043_leached
leacher124014843_leacher
leaches123319343_leaches
lead56038853_lea_d
leads66028493_leads
leady95618603_leady
leaf76441033_lea_f
leafs85721183_leafs
leafy116316213_leafy
leak86233713_lea_k
leaks95923913_leaks
leaky125217723_leaky
leal46043273_lea_l
lean46345243_lea_n
leans55536253_leans
leant56737783_leant
leap66032683_lea_p
leaps75522933_leaps
leapt75027473_leapt
lear47045953_lea_r
learn55322663_learn
lears55938733_lears
leary85927383_leary
leas45954183_lea_s
lease55230263_lease
least56134883_least
leave84723723_leave
leavy115715773_leavy
legacy1256653_legacy
lich96230843_l_ich
loath84918603_loath
loch95527133_l_och
lunch104917243_lunch
lurch104814633_lurch
lych126015763_l_ych
lynch13468983_lynch
mach116134483__mach
merch125417963_merch
neath86020283_neath
obeah1038993obea_h
olea46532723olea__
oleate6318883oleate
oleic7313333oleic_
orach105219233_orach
pac79054083p__ac_
paca85132243p__aca
pace86345773p__ace
pacha126518063p__acha
pack125535443p__ack
pacs85842183p__acs
pact86648723p__act
pacy115328683p__acy
paean77222723paea_n
paeans85118263paeans
pah88853593p__a_h
painch133511323painch
palace104516913palace
palea75028663palea__
paleae84820293palea_e
paleal84716673palea_l
paleate94120003paleate
paleface1545343paleface
panache1458423panache
papacy1547493papacy
paraph13311263paraph
parch125123003p_arch
pash95638133p__ash
pataca10311193pataca
patch125221223p_atch
path99134913p__ath
paunch13369853paunch
pea56657243p_ea__
peaced115818913p_eaced
peaces106324083p_eaces
peached154315883p_eached
peacher144216073p_eacher
peaches144120053p_eaches
peag75431343p_ea_g
peage84723563p_eage
peags86122843p_eags
peak106535203p_ea_k
peaks114825623p_eaks
peaky145718153p_eaky
peal68648103p_ea_l
peals75235493p_eals
pean66147173p_ea_n
peans75437643p_eans
pear69745233p_ea_r
pearl75324463p_earl
pears75138613p_ears
peart76440753p_eart
peas65755063p_ea_s
pease75231113p_ease
peat65967933p_ea_t
peats76140193p_eats
peaty105725693p_eaty
peavy135014843p_eavy
pec76744413p_e_c_
pecan91919033p_ecan
pechs125516203p_e_chs
peck125730683p_e_ck
pecs84634103p_e_cs
peh86740963p_e__h
pelage9515363pelage
pence94924453p_ence
picacho1644733picacho
piece96717993pie_ce
pierce104010393pierce
pilea75123953pilea__
pileate93815923pileate
pinch125619303p_inch
piracy1339473piracy
pitch125018413p_itch
placed114318003pl_aced
placer105117743pl_acer
places104323703pl_aces
placet103923673pl_acet
placid114012543pl_acid
placks144414153pl_acks
plage84520403pl_age
plaice10311553plaice
plaid85118303pl_aid
plain74823303pl_ain
plait75631573pl_ait
plan65833943pl_a_n
planche14299753planche
plane74929143pl_ane
plank115221143pl_ank
plans75731273pl_ans
plant75437113pl_ant
plashy14448873pl_ashy
plasm94114633pl_asm
plat66048873pl_a_t
plate74635113pl_ate
plats75531373pl_ats
platy105021663pl_aty
play95928983pl_a_y
playa105812943pl_aya
playact1446553playact
plays106320773pl_ays
plaza164311063pl_aza
pleaching17257083pleaching
pleaded113511263pleaded
pleader103511753pleader
pleased103712073pleased
pleaser93912343pleaser
pleases94515483pleases
pleated103816633pleated
pleater93916333pleater
pleather1356653pleather
pleb86123813ple__b
plebe95014873ple_be
plebes104313623plebes
plebs95814583ple_bs
pled75231433ple__d
pledge10469473pledge
pleiad947833pleiad
pleiads1045223pleiads
plena75816393ple_na
plenary1237543plenary
plenches153110623plenches
plenish1239943plenish
plenty11311413plenty
plenum1039503plenum
pleon74216383ple_on
pleons84213343pleons
pleura837533pleura
plew97222813ple__w
plews105415353ple_ws
plex137321373ple__x
plexal1536833plexal
plexes155313533plexes
plexor1535253plexor
plexus15377283plexus
pliancy1435593pliancy
pliant83918823pliant
plica9613373pl_ica
plicae10410953plicae
plical10411683plical
plinth11310453plinth
plough12577563plough
pluck134212303pl_uck
plush105614713pl_ush
poachy16388963p_oachy
poleax1547993polea_x
poleaxe1656303poleaxe
polecat11313143polecat
pollack1567333pollack
pomace123111913pomace
pooch124815303p_ooch
porch125918623p_orch
potash1138273potash
potlach14106363potlach
pouch124617083p_ouch
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preacts113211363preacts
preamp1238993preamp
prearm104512343prearm
preface14510923preface
prelacy1437583prelacy
prepack1757643prepack
prerace11414123prerace
prewash1535213prewash
psych1554963p_sych
pujah17478543puja_h
punch125118423p_unch
putsch1334933putsch
quench2036633quench
react74634333_react
relace83122153relace
retch104818303_retch
reteach1237413reteach
roach105717003_roach
search113312423_search
selah8319613sela_h
sheath12412893sheath
sheuch14267043sheuch
sketch1535363sketch
slack115021763sl_ack
slash84719683sl_ash
slatch114510533slatch
sleave94714153sleave
sleaze152611863sleaze
sleazo15257523sleazo
sleazy18267393sleazy
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
speech1347563speech
spinach1435403spinach
splash1168823spl_ash
splotch1442853splotch
stench114111163stench
sumach135310113sumach
tach96132753__tach
tech95925443_te_ch
tench105620003_tench
teuch105214853_teuch
trench114211613trench
unleash1034963unleash
unteach1246143unteach
upleap10106843uplea_p
upleaps1185233upleaps
upleapt11116863upleapt
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wreath124111193wreath
wrench14439353wrench
wretch14326533wretch
yeah106725413_yea_h
yecch15558093_yecch
yech127220533_ye_ch

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.1401276364.3
2DLD Change Limit1127163995.47020606.2
3Display Results3993990.1233243.9
 (SQL Overall)1786913995.73331168.8
 
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.