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

246 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
rends6512995(None) 
bends85628971bends
ends56528521_ends
fends96324971fends
lends65326251lends
mends84927691mends
pends85527191pends
rands65930451rands
reads64835271reads
redds74617831redds
reds56042861re_ds
reeds65430901reeds
rend56136571rend_
rents55935181rents
rinds64826141rinds
rynds9569971rynds
sends65528241sends
tends65425581tends
trends75513541trends
vends95520891vends
wends95822811wends
amends94713282amends
ands57833612_ands
arenas65021992arenas
arenes64928392arenes
bands85233422bands
beads85429502beads
beds75937782be_ds
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702ben_s
bents76033692bents
binds86627472binds
blends96012882blends
bonds86126842bonds
brands95118942brands
breads95419202breads
breeds94914882breeds
brens75823362bren_s
brents84717272brents
bunds85523542bunds
cents74730332cents
creds85418772cre_ds
creeds94714772creeds
deads75726912deads
deeds75423762deeds
denes65639722denes
dens55945072den_s
dents65031802dents
dreads84115022dreads
eds46638922_e_ds
elds56324852_elds
emends95711432emends
end46834352_end_
engs56121392_engs
ens37245922_en_s
ernes55224812ernes
erns45428222ern_s
feds85234312fe_ds
feeds94921142feeds
fend84832972fend_
fens76139762fen_s
feods99516852feods
feuds95914882feuds
fiends104110292fiends
finds95424822finds
fonds95824822fonds
friends11396742friends
fronds106412342fronds
funds94119252funds
geds66730812ge_ds
gelds75118342gelds
genes65133092genes
gens55740072gen_s
gents65729612gents
genus65319832genus
grands84218242grands
greeds84314282greeds
grinds84511842grinds
hands95327382hands
heads95127112heads
heeds95420422heeds
hens75642572hen_s
hents87330742hents
herds96424682herds
hinds96721472hinds
kendo105113222kendo
kendos114510662kendos
kenos95220622kenos
kens85435232ken_s
kinds106221812kinds
lands65426902lands
leads66028492leads
lend56233672lend_
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leuds66214812leuds
meads85425322meads
meds75735362me_ds
meeds84920272meeds
melds84822382melds
menads95514382menads
mend75334032mend_
menus75822842menus
minds85427122minds
needs65719632needs
nenes55329672nenes
nerds65719252nerds
oreads73915772oreads
peds75835242pe_ds
pend75934532pend_
penes75839222penes
penis75129322penis
pens65649642pen_s
ponds85323402ponds
rads56046602r_ads
raids65827512raids
rand55839572rand_
randy95022082randy
ranids75118702ranids
ranis55235832ranis
ranks95225732ranks
rants55935342rants
read55942532read_
readd74617132readd
readds84111642readds
ready94821502ready
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
rebids94015532rebids
rebinds104511872rebinds
rebs65733562re_bs
rebus75721112rebus
recks115625132recks
recs65734182re_cs
red46755802re_d_
redd66323172re_dd
rede55037662re_de
redes65139122redes
redo56029362re_do
redos65126762redos
reed55549622reed_
reedy910020282reedy
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192re_es
refinds114512122refinds
refs75732242re_fs
refunds11448622refunds
reges65628782reges
regs55436572re_gs
reifs84819092reifs
reinks105012152reinks
reins56234562reins
reis45343232re_is
relands85214882relands
relends84013252relends
remands104914882remands
remends105013032remends
reminds104614792reminds
rems66237722re_ms
renal55929502renal
rended84524102rended
render74024142render
renders83821672renders
renest64529712renest
renew83917512renew
renews93811752renews
renig64518912renig
renigs74314592renigs
renin54830032renin
renins64526452renins
rent46661242ren_t
rente54733782rente
rentes65431192rentes
repos74725792repos
repps95114342repps
reps65937952re_ps
res35565042re__s
resends83513712resends
resids74219152resids
resods74116302resods
rests54935872rests
rets45352562re_ts
revs75027052re_vs
reweds104412302reweds
rewinds114810482rewinds
rexes124526952rexes
rids56539542r_ids
rind56535602rind_
rindy95717392rindy
rings65029172rings
rinks94827102rinks
rins46153192rin_s
roads66523622roads
rods56442062r_ods
rondo65218372rondo
rondos74616732rondos
roods65125282roods
rounds73615622rounds
rudds74811702rudds
runes55530222runes
rungs611819402rungs
runs46438072run_s
runts55927632runts
rynd86414102rynd_
sands65228582sands
scends95213002scends
seeds64330062seeds
send55237292send_
shends105313772shends
sneds65715352sneds
spends94714472spends
teds54932572te_ds
teinds738262teinds
tend56433772tend_
tendu67216002tendu
tendus75111182tendus
tens45647412ten_s
tents56434212tents
treads74817922treads
trend64817452trend_
trendy10469602trendy
upends9438762upends
velds95615582velds
vend86626422vend_
vents86125932vents
venus84918902venus
wands96425482wands
weds86628932we_ds
weeds95222212weeds
welds94719162welds
wend85330452wend_
wens76337932wen_s
winds95425602winds
wrens85016242wren_s
wynds126310372wynds
yens75832262yen_s
zeds145821802ze_ds

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 Filter178691538000.0802233637.5
2DLD Change Limit538002461.64032804.9
3Display Results2462460.0633904.8
 (SQL Overall)1786912461.783100219.3
 
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.