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

187 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
besnows124515(None) 
besnow1145711besnow_
bestows1248861bestows
beanos85516512beano_s
beknots1335082beknots
bellows124313302bellows
belows114614182be_lows
besnowed14124412besnowed
besoms105712732bes_oms
besots86415452bes_ots
bestow1149462bestow_
bestrows1337042bestrows
enows85115492_e_nows
reshows132510452reshows
resows93915352res_ows
snows84719892__snows
barlows12259973barlows
barrows123411683barrows
bashaws15347713bashaws
basions94213953basions
bassos85313703basso_s
beacons11410733beacons
beanies93821093beanies
beano75421553beano__
beans75734693bean__s
bebops1237623be_bops
beckons15279143beckons
beclogs1237073beclogs
beclown1435423beclown
beclowns1544683beclowns
becrowd1555173becrowd
becrowds1683773becrowds
bedews12398943be_dews
bedgown1443773bedgown
bedgowns1543113bedgowns
befogs1246453be_fogs
befools1236433befools
behowl1445533be_howl
behowls1534443be_howls
beings94613033bein_gs
beknot1239763bekno_t
bellow114213353bellow_
belongs10408223belongs
belons84119413be_lons
below104617193be_low_
bends85628973be_n_ds
bendys12518383be_ndys
benes75536233be_n_es
bennes86019013be_nnes
bennets94712163bennets
bennies93917313bennies
bennis84314803be_nnis
bens65945703be_n__s
bentos86218303be_ntos
bents76033693be_n_ts
benzols1836673benzols
bescour1145203bescour
bescours1245093bescours
beseems1175913beseems
beses75830723bes__es
besets85718803bes_ets
beshadows1842513beshadows
beshout12311843beshout
beshouts1346763beshouts
beshrews1643163beshrews
besides104814533besides
besmoke15416623besmoke
besmokes16406363besmokes
besmuts1134683besmuts
besnowing1544123besnowing
besom95716973bes_o_m
besot76429713bes_o_t
bespoke15468113bespoke
bespouse1245113bespouse
bestirs9311133bestirs
bestowal1344513bestowal
bestowals1443223bestowals
bestowed14156623bestowed
bestower13126213bestower
bestowers14135333bestowers
bestrews1335603bestrews
bestrow1237253bestrow_
bestrown1345203bestrown
bests75932613bes__ts
bestuds10326753bestuds
betons84919553be_tons
bettors93312473bettors
bevors111610343be_vors
beyonds1335063beyonds
billows123611293billows
binocs1039923b_inocs
bishops1437033bishops
bisons83914373bis_ons
blesboks1643043blesboks
blows105423833b__lows
borrows12349253borrows
bosoms104913053bos_oms
bosons85016653bos_ons
bostons9312903bostons
bows96242863b___ows
bowwows1454123bowwows
brows105425983b__rows
burnous938823burnous
burrows12399093burrows
busboys14325023busboys
censors93611843censors
cestos84718093cesto_s
despots10319683despots
elbows1196713_elbows
embows1396823_embows
endows104610423_endows
enols54718403_e_nols
enow77819873_e_now_
escots84211743_escots
escrows1235803_escrows
esnes54817363_esn_es
estops84011223_estops
fellows134212433fellows
genoas74013623ge_noas
genoms94412483ge_noms
gessoes838293gessoes
heinous1038853heinous
kenos95220623ke_no_s
knows124912413__knows
lenos56024863le_no_s
lesbos837403lesbo_s
lesions73813873lesions
lessons73811023lessons
lessors73610523lessors
meadows1337333meadows
mellows123812233mellows
meows104612683me__ows
mesnes85216213mesn_es
mesons83215843mes_ons
minnows1234913minnows
misknows1743063misknows
nestors73614973nestors
nows75738233___nows
pennons939713pennons
pernods1038483pernods
pesos77221623pes_o_s
pestos84719083pesto_s
preshows16267023preshows
reavows1335273reavows
reendows12234683reendows
reflows13258983reflows
reglows11288843reglows
regrows11269153regrows
reknots1136783reknots
renews93811753re_news
renown9369983re_nown
renowns10277833re_nowns
replows12329703replows
resaws93713513res_aws
resews94814173res_ews
reshoes102316033reshoes
reshow123111433reshow_
reshown13257903reshown
resinous838503resinous
resods74116303res_ods
resow88217243res_ow_
resown94112923res_own
respots92912763respots
scows106617803__scows
segnos73610443segno_s
senors63620793se_nors
sensors73514643sensors
serows96016393se_rows
shows115324583__shows
slows85323463__slows
snaws86116363__snaws
snobs74716153__snobs
snogs66017493__snogs
snots55225123__snots
snow76324793__snow_
snowy115011563__snowy
sows75342493__s_ows
stows86622703__stows
tenons62916603te_nons
tenors63217753te_nors
tensors72712373tensors
testons7313563testons
venoms114211213ve_noms
venous93713193ve_nous
winnows1334533winnows
xenons132710483xe_nons
yellows13329603yellows

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271877.04619021.7
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.49923828.6
 
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.