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

209 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
beknot123976(None) 
beknots1335081beknots
reknot10311731reknot
beano75421552beano_
beanos85516512beanos
begot84625952be_got
bennet84823362bennet
bent67759912be_n_t
bento75922952be_nto
besnow1145712besnow
besot76429712be_sot
bowknot1645772bowknot
knot85630502__knot
reknit10312532reknit
reknots1136782reknots
unknot1037412unknot
ballot84624093ballot
bankit123617043bankit
banknote1444833banknote
bannet84925333bannet
beacon10511373beacon
bean66443863bean__
beaned95621473beaned
beanie83618593beanie
beans75734693bean_s
beast76338643be_ast
beat66168303be__at
beaut75135213be_aut
bebop11410793be_bop
becket144619883becket
beckon14309383beckon
beckons15279143beckons
beclog1136863beclog
bedpost1247243bedpost
bedsit9312843bedsit
been65335783been__
beet66457543be__et
befit105222663be_fit
befog1159013be_fog
befool1137713befool
befret11315963befret
begat86629723be_gat
beget85632553be_get
begirt9412683begirt
begone9512133begone
behest11314613behest
behoof1458683behoof
beignet101510963beignet
being84920503bein_g
beings94613033beings
bekiss1236373bekiss
beknight1843563beknight
beknotted1642343beknotted
bellow114213353bellow
belon73924113be_lon
belong93411043belong
belons84119413belons
below104617193be_low
belt65754033be__lt
bemist105216953bemist
bemixt174510363bemixt
ben56554923be_n__
bench125619503be_nch
bend76435263be_n_d
bends85628973be_nds
bendy115017253be_ndy
bene66439493be_n_e
benes75536233be_nes
benne76521123be_nne
bennes86019013bennes
bennets94712163bennets
benni74715363be_nni
bennis84314803bennis
benny105217363be_nny
bens65945703be_n_s
bentos86218303bentos
bents76033693be_nts
benzol1756993benzol
bereft114317303bereft
beret74946363be_ret
beset76739133be_set
beshout12311833beshout
besmut10310653besmut
besnows1245153besnows
besom95716973be_som
besots86415453be_sots
best66355323be__st
bestow1149463bestow
bet58376673be___t
beton76022063be_ton
betons84919553betons
betony114211583betony
betook12439603betook
betroth1247543betroth
bettor83612223bettor
bevor101510813be_vor
bewept13410323bewept
beyond1237073beyond
bezant17814543bezant
bhoot104322093b_hoot
bigot84828323b_igot
binit76431583b_init
bint67355043b_in_t
biont7727163bion_t
blent76230953blen_t
blot65842323b__lot
blunt75525023blun_t
bonnet85524633bonnet
boot67759373b__oot
bot59680403b___ot
bowknots1743063bowknots
bowpot13410073bowpot
brant74742173bran_t
brent75734133bren_t
brulot8912213brulot
brunet84419293brunet
brunt75728753brun_t
bundt85824853b_undt
bunko115514513bunko_
bunkos124210323bunkos
bunt65850853b_un_t
burbot10815653burbot
burnet84326173burnet
burnout9310453burnout
burnt75230323burn_t
cannot83616773cannot
cenote83715843ce_note
cent67451013ce_n_t
cento76625173ce_nto
dekko936393dekko_
dekkos1034103dekkos
denote74118043de_note
dent57158413de_n_t
depot85727923de_pot
despot93413293despot
enol45823823_e_nol
enow77819873_e_now
ergot65422893_ergot
escot75320083_escot
feint84732253fein_t
gemot84024233ge_mot
genet66038683ge_net
genoa64315823ge_noa
genom83716843ge_nom
gent56954393ge_n_t
helot85332683he_lot
hent76656383he_n_t
heriot9422343heriot
inkpot1237813inkpot
jennet134714953jennet
keno87926433ke_no_
kenos95220623ke_nos
kent86846963ke_n_t
keynote1443903keynote
knit85728143__knit
knob107417013__knob
knop107116593__knop
knots95614723__knots
knout95018263__knout
know116115843__know
leant56737783lean_t
leno47331393le_no_
lenos56024863le_nos
lent46360533le_n_t
lento57223393le_nto
meant76537203mean_t
meno66031353me_no_
merlot83217603merlot
mikvot1556763mikvot
nekton1036583nekton
not39474663___not
obento837893obe_nto
peanut8318183peanut
pekoe114612363pek_oe
pennon8310643pennon
pent66559073pe_n_t
pernod9310453pernod
pinot78737293_pinot
reboot84119333reboot
reknits1137073reknits
rennet64624853rennet
rent46661243re_n_t
replot83818593replot
repot75132623re_pot
reshot93519633reshot
respot83117633respot
segno64814743segno_
segnos73610443segnos
sennet64224143sennet
sennit63117923sennit
senor53822793se_nor
sent46963013se_n_t
sexpot1539543sexpot
snot44745443__snot
sukkot936633sukkot
teapot8416763teapot
telnet6518833telnet
tenet55542213te_net
tenon53320513te_non
tenor53620253te_nor
tent46159863te_n_t
topknot1346423topknot
unknit1068593unknit
unknots1144303unknots
venom103914863ve_nom
vent76049053ve_n_t
went76051873we_n_t
xenon122612453xe_non
zealot15313473zealot

Search took 5 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.1261418182.5
2DLD Change Limit1127162094.71623900.8
3Display Results2092090.0633317.5
 (SQL Overall)1786912094.90536430.4
 
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.