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

211 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
besnow114571(None) 
besnows1245151besnows
bestow1149461bestow
beano75421552beano_
beanos85516512beanos
beknot1239762beknot
bellow114213352bellow
below104617192be_low
besnowed14124402besnowed
besom95716972bes_om
besot76429712bes_ot
bestows1248862bestows
bestrow1237242bestrow
enow77819872_e_now
reshow123111432reshow
resow88217242res_ow
snow76324792__snow
barlow112911423barlow
barrow114512763barrow
bashaw14349303bashaw
basion84315853basion
basso76017283basso_
bassos85313703bassos
beacon10511373beacon
bean66443863bean__
beaned95621473beaned
beanie83618593beanie
beans75734693bean_s
bebop11410793be_bop
beckon14309383beckon
beclog1136863beclog
beclown1435423beclown
becrowd1555173becrowd
bedew114513033be_dew
bedgown1443773bedgown
been65335783been__
befog1159013be_fog
befool1137713befool
begone9512133begone
begot84625953be_got
behoof1458683behoof
behowl1445533be_howl
being84920503bein_g
beings94613033beings
beknots1335083beknots
bellows124313303bellows
belon73924113be_lon
belong93411043belong
belons84119413belons
belows114614183be_lows
ben56554923be_n__
bench125619503be_nch
bend76435263be_n_d
bends85628973be_nds
bendy115017253be_ndy
bene66439493be_n_e
benes75536233be_nes
benne76521123be_nne
bennes86019013bennes
bennet84823363bennet
benni74715363be_nni
bennis84314803bennis
benny105217363be_nny
bens65945703be_n_s
bent67759913be_n_t
bento75922953be_nto
bentos86218303bentos
bents76033693be_nts
benzol1756993benzol
bes56557433bes___
bescour1145203bescour
beseem1069083beseem
beses75830723bes_es
beset76739133bes_et
besets85718803besets
beshadow1742303beshadow
beshout12311833beshout
beshrew1554393beshrew
beside95114613beside
besmoke15416623besmoke
besmut10310653besmut
besnowing1544123besnowing
besoms105712733besoms
besots86415453besots
bespoke15468113bespoke
best66355323bes__t
bested94922753bested
bestir8311163bestir
bestowal1344513bestowal
bestowed14156613bestowed
bestower13126203bestower
bestrew1248003bestrew
bestrown1345193bestrown
bestrows1337043bestrows
bests75932613bes_ts
bestud9439303bestud
beton76022063be_ton
betons84919553betons
betony114211583betony
betook12439603betook
bettor83612223bettor
bevor101510813be_vor
beyond1237073beyond
billow114111223billow
bishop1336943bishop
bison75716983bis_on
bisons83914373bisons
blesbok1543123blesbok
blow95827193b__low
borrow114310723borrow
bosom95516923bos_om
boson76019733bos_on
bosons85016653bosons
boston8513043boston
bow87051903b___ow
bowwow1334463bowwow
brow97228443b__row
burrow114610803burrow
busboy13307443busboy
censor84011283censor
cestoi84511953cestoi
cestos84718093cestos
despot93413293despot
elbow10117703_elbow
embow1297563_embow
endow94510983_endow
enol45823823_e_nol
enows85115493_e_nows
erenow937373erenow
escot75320083_escot
escrow1135913_escrow
esne47018793_esn_e
esnes54817363_esnes
estop74312103_estop
fellow123712743fellow
genoa64315823ge_noa
genom83716843ge_nom
gesso649603gesso_
keno87926433ke_no_
kenos95220623ke_nos
know116115843__know
leno47331393le_no_
lenos56024863le_nos
lesbo739253lesbo_
lesbos837403lesbos
lesion64715063lesion
lesson64412043lesson
lessor64010603lessor
meadow1237403meadow
mellow114112223mellow
meno66031363me_no_
meow95117883me__ow
mesne75116293mesn_e
mesnes85216213mesnes
meson74118313mes_on
mesons83215843mesons
minnow1135583minnow
misknow1643213misknow
nestor63713423nestor
now65950193___now
pennon8310643pennon
pernod9310453pernod
peso66925823pes_o_
pesos77221623pes_os
pesto75723723pesto_
pestos84719083pestos
preshow15237413preshow
reavow1235723reavow
reendow11285063reendow
reflow12379653reflow
reglow10339403reglow
regrow10309883regrow
reknot10311733reknot
renew83917513re_new
renown9369983re_nown
replow114210343replow
resaw84117253res_aw
resew84519503res_ew
reshod103012233reshod
reshoe92816483reshoe
reshot93519633reshot
reshown13257903reshown
reshows132510453reshows
resod64720053res_od
resown94112923res_own
resows93915353res_ows
respot83117633respot
scow96021423__scow
segno64814743segno_
segnos73610443segnos
senor53822793se_nor
sensor63813833sensor
serow86720443se_row
show106229193__show
slow77729493__slow
snaw78923073__snaw
snob65825593__snob
snog55623633__snog
snot44745453__snot
snows84719893__snows
snowy115011563__snowy
sow66554763__s_ow
stow77325743__stow
tenon53320513te_non
tenor53620253te_nor
tensor63812673tensor
teston6313303teston
venom103914863ve_nom
winnow1234593winnow
xenon122612453xe_non
yellow12429883yellow

Search took 7 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.1231452772.4
2DLD Change Limit1127162115.89019136.8
3Display Results2112110.0633349.2
 (SQL Overall)1786912116.07629409.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.