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

231 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
pends8552719(None) 
bends85628971bends
ends56528521_ends
fends96324971fends
lends65326251lends
mends84927691mends
peds75835241pe_ds
pend75934531pend_
penes75839221penes
penis75129321penis
pens65649641pen_s
ponds85323401ponds
rends65129951rends
sends65528241sends
spends94714471spends
tends65425581tends
upends9438761upends
vends95520891vends
wends95822811wends
amends94713282amends
ands57833612_ands
appends1236392appends
bands85233422bands
beads85429502beads
beds75937782be_ds
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702ben_s
bents76033692bents
binds86627472binds
blends96012882blends
bonds86126842bonds
bunds85523542bunds
cents74730332cents
deads75726912deads
deeds75423762deeds
denes65639722denes
dens55945072den_s
dents65031802dents
depends11348992depends
eds46638922_e_ds
elds56324852_elds
emends95711432emends
end46834352_end_
engs56121392_engs
ens37245922_en_s
expends17217082expends
feds85234312fe_ds
feeds94921142feeds
fend84832972fend_
fens76139762fen_s
feods99516852feods
feuds95914882feuds
fiends104110292fiends
finds95424822finds
fonds95824822fonds
funds94119252funds
geds66730812ge_ds
gelds75118342gelds
genes65133092genes
gens55740072gen_s
gents65729612gents
genus65319832genus
hands95327382hands
heads95127112heads
heeds95420422heeds
hens75642572hen_s
hents87330742hents
herds96424682herds
hinds96721472hinds
impends12376802impends
kendo105113222kendo
kendos114510662kendos
kenos95220622kenos
kens85435232ken_s
kinds106221812kinds
lands65426902lands
leads66028492leads
lend56233672lend_
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leuds66214812leuds
meads85425322meads
meds75735362me_ds
meeds84920272meeds
melds84822382melds
menads95514382menads
mend75334022mend_
menus75822842menus
minds85427122minds
needs65719632needs
nenes55329672nenes
nerds65719252nerds
opens76118552open_s
pads76742952p_ads
panda85022612panda
pandas95521962pandas
pandy115021172pandy
panes76148692panes
pangs84628662pangs
pans65855722pan_s
pants76536922pants
pards85634332pards
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pe_as
peats76140192peats
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
ped66751522pe_d_
pedes85327282pedes
peed76239182peed_
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
peins76128062peins
pekes114623562pekes
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pen56558842pen__
penal75228372penal
pence94924452pence
pended103819012pended
pengo84317592pengo
pengos94612412pengos
penna74520202penna
penne75423852penne
penni74617902penni
pennis84315742pennis
penny105119452penny
pent66559072pen_t
pentads1039522pentads
peones83821042peones
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
perdu84216272perdu
perdus93711272perdus
perdy115417322perdy
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
pernods1038482pernods
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
pets66248332pe_ts
pews95731532pe_ws
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pin_s
pints75936222pints
pleads94613952pleads
plods85719292plods
pods76540152p_ods
poinds93511142poinds
pond75530492pond_
pones74547042pones
pongs85526342pongs
pons65850602pon_s
poods85124752poods
pounds93714382pounds
prods85523552prods
pseuds944792pseuds
puds75630512p_uds
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punts75828002punts
rands65930452rands
reads64835272reads
redds74617832redds
reds56042862re_ds
reeds65430902reeds
rend56136572rend_
rents55935182rents
rinds64826142rinds
rynds9569972rynds
sands65228582sands
scends95213002scends
seeds64330062seeds
send55237292send_
shends105313772shends
sneds65715352sneds
speeds94316052speeds
spend85619332spend_
spendy124911142spendy
teds54932572te_ds
teinds738262teinds
tend56433772tend_
tendu67216002tendu
tendus75111182tendus
tens45647412ten_s
tents56434212tents
trends75513542trends
upend85011042upend_
upsends10265292upsends
velds95615582velds
vend86626422vend_
vents86125932vents
venus84918902venus
wands96425482wands
weds86628932we_ds
weeds95222212weeds
welds94719162welds
wend85330452wend_
wens76337932wen_s
winds95425602winds
wynds126310372wynds
yens75832262yen_s
zeds145821802ze_ds

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002312.09625667.9
3Display Results2312310.1231878.0
 (SQL Overall)1786912312.31277288.5
 
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.