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

286 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
pend7593453(None) 
bend76435261bend
end46834351_end
fend84832971fend
lend56233671lend
mend75334021mend
ped66751521pe_d
peed76239181peed
pen56558841pen_
pends85527191pends
pens65649641pens
pent66559071pent
pond75530491pond
rend56136571rend
send55237291send
spend85619331spend
tend56433771tend
upend85011041upend
vend86626421vend
wend85330451wend
amend85717752amend
and47244162_and
aped78538152ape_d
append1138272append
band76740902band
bead75937922bead
bed67950622be_d
ben56554922ben_
bends85628972bends
bendy115017252bendy
bene66439492bene
bens65945702bens
bent67759912bent
bind76234502bind
blend85317452blend
bond75334362bond
bund75530662bund
cent67451012cent
dead65434242dead
deed65340902deed
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
depend103510922depend
ed38645182_e_d
eld46733792_eld
emend86214892emend
en28052392_en_
ends56528522_ends
eng46726782_eng
ens37245922_ens
expend16247502expend
fed76548352fe_d
feed84538902feed
fen66851352fen_
fends96324972fends
fens76139762fens
feod815523002feod
feud86523022feud
fiend95312982fiend
find87532602find
fond86330952fond
fund85624982fund
ged57044532ge_d
geed65435502geed
geld65828432geld
gen45950512gen_
gene56237222gene
gens55740072gens
gent56954392gent
genu55929072genu
hand86833702hand
head87137172head
heed86437602heed
held85330402held
hen67555272hen_
hens75642572hens
hent76656382hent
herd84933062herd
hind85529752hind
impend11478782impend
jeed125428502jeed
ken76343982ken_
kendo105113222kendo
keno87926432keno
kens85435232kens
kent86846962kent
kind96128552kind
land56337302land
lead56038852lead
led46254552le_d
lends65326252lends
leno47331392leno
lens46146492lens
lent46360532lent
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meed74934702meed
meld75830472meld
men59252842men_
menad85918982menad
mends84927692mends
meno66031352meno
menu65130222menu
mind75434362mind
need54934152need
nene45932062nene
nerd56624942nerd
oped76230152ope_d
open66427002open_
opened94311862opened
opens76118552opens
pad68057322p_ad
paid75737482paid
pan58466442pan_
panda85022612panda
pandy115021172pandy
pane64950282pane
paned85437182paned
pang75336282pang
pans65855722pans
pant66061252pant
pard76441322pard
pe47649032pe__
pea56657242pe_a
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
peans75437642peans
pear69745232pear
peas65755062peas
peat65967932peat
pec76744412pe_c
pech116125452pech
peck125730682peck
pecs84634102pecs
peds75835242peds
pee56066512pe_e
peek106031432peek
peel65535612peel
peen65938082peen
peened94318152peened
peens76428192peens
peep85833692peep
peer66238352peer
pees65257372pees
peg65843062pe_g
pegs75531762pegs
peh86740962pe_h
pehs95625762pehs
pein65834942pein
peined94918842peined
peins76128062peins
peke105926202peke
pele65539552pele
pelf97031452pelf
pelt67651082pelt
penal75228372penal
pence94924452pence
pended103819012pended
penes75839222penes
pengo84317592pengo
penis75129322penis
penna74520202penna
penne75423852penne
penned94217612penned
penni74617902penni
penny105119452penny
pentad9313762pentad
peon65635242peon
peons75327182peons
peony105717562peony
pep76447082pe_p
pepo87622152pepo
peps85134512peps
per56353092pe_r
perdu84216272perdu
perdy115417322perdy
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
pernod9310452pernod
perp89029892perp
pert66759322pert
perv97224812perv
pes57259782pe_s
peso66925822peso
pest65555292pest
pet56477302pe_t
pets66248332pets
pew86442302pe_w
pews95731532pews
pied75035362pied
pin57066722pin_
pina65842632pina
pine67755712pine
pined85935322pined
ping75943592ping
pink107039382pink
pins65558452pins
pint66963172pint
piny911838352piny
plead85818462plead
pled75231432pled
plena75816392plena
plod76723272plod
pod66351482p_od
poind84217912poind
ponds85323402ponds
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
pood75934322pood
pound84417862pound
preed85128112preed
prod76129502prod
pseud867042pseud
pud65836652p_ud
pun58846512pun_
puna65331652puna
pung75429632pung
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
rand55839562rand
read55942532read
red46755802re_d
redd66323172redd
reed55549622reed
rends65129952rends
rent46661242rent
rind56535602rind
rynd86414102rynd
sand55338462sand
scend85516292scend
seed55549482seed
sen36058522sen_
sends65528242sends
sene46848052sene
sent46963012sent
shend94719972shend
sned56026052sned
sped76031492spe_d
speed85526622speed
spends94714472spends
spendy124911142spendy
spent75532832spent
ted46446562te_d
teed55439262teed
teind6213612teind
ten35856112ten_
tends65425582tends
tendu67216002tendu
tens45647412tens
tent46159862tent
trend64817452trend
upends9438762upends
upsend9356882upsend
veld85323202veld
vena76126292vena
vends95520892vends
vent76049052vent
wand85833872wand
wed75843622we_d
weed85637512weed
weld84727732weld
wen66249602wen_
wends95822812wends
wens76337932wens
went76051872went
wind85533852wind
wynd116114462wynd
yeld811423872yeld
yen66847382yen_
yens75832262yens
yond86122312yond
zed135431172ze_d

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.0802233637.5
2DLD Change Limit298722860.96630923.4
3Display Results2862860.0634539.7
 (SQL Overall)1786912861.109161128.0
 
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.