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 “pled” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

309 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
pled7523143(None) 
bled75729311bled
fled85429771fled
gled65631141gled
led46254551_led
paled85538721paled
ped66751521p_ed
peed76239181peed
pied75035361pied
piled85232991piled
plea66830601plea
plead85818461plead
pleb86123811pleb
plew97222811plew
plex137321371plex
plied85118591plied
plod76723271plod
poled84934841poled
puled84926521puled
sled55334371sled
abed79734132abed
abled86926832abled
aced79540882aced
aged67334252aged
ahed89536252ahed
ailed66240282ailed
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
aped78538152aped
awed88436032awed
axed128829612axed
axled135315812axled
baled85436442baled
bed67950622_bed
bleb85425222bleb
bleed85019802bleed
blend85317452blend
blet66247672blet
blew94722432blew
blued84520322blued
bred75130972bred
clad76225822clad
clef97028182clef
clew95520572clew
clod76124612clod
clued84917682clued
coed77140542coed
coled85540762coled
cred76530882cred
cued76329562cued
deed65340902deed
deled75326542deled
died66137852died
doled75430912doled
dyed96720762dyed
ed38645182__ed
eked96718022eked
eld46733792el_d
exed125420592exed
eyed86623232eyed
fed76548352_fed
feed84538902feed
filed95331902filed
flea75628492flea
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
flied96519432flied
flued95021252flued
gaed66031512gaed
ged57044532_ged
geed65435502geed
geld65828432geld
gied64631982gied
glad65624012glad
glede75517832glede
gleds75417892gleds
glee55239062glee
gleed75320572gleed
gleg66219802gleg
glen56027202glen
gley85724652gley
glued75118362glued
haed86338582haed
haled95335822haled
heed86437602heed
held85330402held
hied85434042hied
hoed87837982hoed
holed95634132holed
hued86925852hued
iced78721892iced
idled74915212idled
ilea45931462ilea
ilex115822032ilex
impled113812512impled
ired55131872ired
isled64615992isled
jeed125428502jeed
lad48165702_lad
lea37660182_lea
lead56038852_lead
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
lend56233672_lend
les35663072_les
let36481472_let
leu36047402_leu
leud57223422_leud
lev66139422_lev
lewd85716592_lewd
lex107943822_lex
ley66246812_ley
lez125541312_lez
lid47453522_lid
lied55838092lied
med66146742_med
meed74934702meed
meld75830472meld
muled85824432muled
naled65525052naled
need54934152need
ogled75915962ogled
ohed87825182ohed
oiled64429472oiled
old47033462ol_d
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
oped76230152oped
opted84914272opted
owed86833872owed
paced106931682paced
pad68057322p_ad
paged95926782paged
paid75737482paid
pale66055012pale_
palea75028662palea
paler75436932paler
pales75753802pales
palet74650802palet
palled94625162palled
palmed114314642palmed
palped114513642palped
paned85437182paned
pard76441322pard
pared86946762pared
parled94626292parled
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pe47649032p_e_
pea56657242p_ea
pealed95322812pealed
pec76744412p_ec
peds75835242p_eds
pee56066512p_ee
peek106031432peek
peel65535612peel
peeled94119712peeled
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
peg65843062p_eg
peh86740962p_eh
pele65539552pele
peles75738082peles
pelf97031452pelf
pelt67651082pelt
pelted94617762pelted
pen56558842p_en
pend75934532pend
pep76447082p_ep
per56353092p_er
pes57259782p_es
pet56477302p_et
pew86442302p_ew
phew128417112phew
pie55457402pie_
pier66035292pier
pies66949602pies
piked125623312piked
pile65649692pile_
pilea75123952pilea
pilei74021782pilei
piles74742612piles
pilled94222752pilled
pined85935322pined
piped105123162piped
placed114318002placed
plaid85118302plaid
plan65833942plan
planed94420912planed
plat66048872plat
plated95225772plated
play95928982play
played124815032played
pleads94613952pleads
pleas75627032pleas
pleat74734472pleat
plebe95014872plebe
plebs95814582plebs
pledge10469492pledge
pleiad947832pleiad
plena75816392plena
pleon74216382pleon
plews105415352plews
plie65127392plie
plier75221282plier
plies74526512plies
plods85719292plods
plop86625742plop
plot66141232plot
plow95923232plow
plowed124213202plowed
ploy96123602ploy
ployed124310562ployed
plug74915992plug
plum85122102plum
plumed114412882plumed
plus66324832plus
ply86323552pl_y
plyer106214332plyer
pod66351482p_od
poem86225772poem
poet65552902poet
poked125425392poked
pole65951302pole_
poler74431792poler
poles75351002poles
polled94022002polled
pond75530492pond
pood75934322pood
pooed85226242pooed
pooled94619812pooled
pored85234512pored
posed85828412posed
poxed154817862poxed
pree67044732pree
preed85128122preed
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
pried84426862pried
prod76129502prod
pseud867042pseud
pud65836652p_ud
puked124716222puked
pule65040952pule_
puler74826622puler
pules74538812pules
pulled94322192pulled
pulped114612532pulped
pulsed94013722pulsed
purled94520752purled
pye86432502pye_
pyes95528992pyes
red46755802_red
reed55549622reed
repled93319782repled
riled65833252riled
rued55729792rued
ruled65822522ruled
seed55549482seed
shed86536152shed
sleds64418852sleds
slew76228232slew
slid55828982slid
slued64220512slued
sned56026052sned
soled65835172soled
spaed85522272spaed
sped76031492sped
speed85526622speed
spied85427712spied
spiled94621992spiled
spued84918472spued
sued56537932sued
ted46446562_ted
teed55439262teed
tied55535212tied
tiled64832942tiled
toed56137042toed
toled65934922toled
unled64021072unled
upped103715162upped
used55722822used
veld85323202veld
vied86328632vied
voled95323722voled
waled94330992waled
wed75843622_wed
weed85637512weed
weld84727732weld
wiled95231552wiled
wyled124611842wyled
yeld811423872yeld
ylem9217892ylem
zed135431172_zed

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298723091.11026911.7
3Display Results3093090.1532019.6
 (SQL Overall)1786913091.546115582.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.