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

197 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
sewn7612433(None) 
hewn106719851hewn
sawn75428161sawn
seen46943121seen
sen36058521se_n
sew66247261sew_
sewan85921291sewan
sews75836021sews
shewn115715701shewn
sown75127451sown
aeon45634612aeon
awn68035912_awn
bean66443862bean
been65335782been
ben56554922be_n
dawn85624202dawn
dean56039482dean
den47554342de_n
dew77139922dew_
dewan95718042dewan
dews86230602dews
dewy115419022dewy
down86427492down
en28052392_e_n
eon36052082_eon
ern35738352_ern
ewe66630982_ewe
fawn105321952fawn
fen66851352fe_n
fern76129322fern
few95436962few_
gen45950512ge_n
gown85724072gown
hen67555272he_n
hern76134892hern
hew97642722hew_
hews105631572hews
jean116629282jean
jeon116821442jeon
jew135129082jew_
jews145822082jews
keen84830402keen
ken76343982ke_n
kern85326212kern
lawn75925632lawn
lean46345242lean
lewd85716592lewd
lown76929292lown
mawn94424132mawn
mean65538082mean
men59252842me_n
mew86137732mew_
mewl95618322mewl
mews96629332mews
mown95424442mown
neon47026422neon
new66237092new_
news76127372news
newt76933742newt
own66429702_own
pawn94625302pawn
pean66147172pean
peen65938082peen
pein65834942pein
pen56558842pe_n
peon65635242peon
pew86442302pew_
pews95731532pews
rein46040892rein
resewn9459812resewn
rewan85623662rewan
rewin85623962rewin
rewon86920572rewon
sain45551292sain
saw68255352saw_
saws75839482saws
scan65530452scan
sea36161292se_a
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
seawan94111222seawan
sec55945322se_c
secs65033892secs
sect67443622sect
sedan65620422sedan
see35772262se_e
seed55549482seed
seek85935482seek
seel45042982seel
seem65438562seem
seep66540342seep
seer45547042seer
sees45361052sees
seg45544882se_g
segni63712482segni
segno64814742segno
sego56525182sego
segs54933882segs
sei36048932se_i
seif75638732seif
seine55732872seine
seis45542392seis
sel38253322se_l
self75138292self
sell45840612sell
sels46345982sels
seme65836652seme
semen75724102semen
semi65127222semi
send55237292send
sene46848052sene
senna54617982senna
sent46963012sent
sept65844362sept
ser36752402se_r
sera46141392sera
sere46153472sere
serf76340112serf
serin55434442serin
sers45746652sers
set36681252se_t
seta45637312seta
seton55223542seton
sets45549502sets
sett45949052sett
seven84118312seven
sewans95215902sewans
sewar85421092sewar
sewed95325162sewed
sewer84426212sewer
sewing103819622sewing
sex107043222se_x
sext117338092sext
sexy146418022sexy
shawn116417612shawn
sheen85023312sheen
shew108030762shew_
shews115924712shews
shin75634302shin
shown115216472shown
shun75122772shun
shwa106014962shwa
sign55523052sign
sin36265892s_in
skean94415622skean
skeen94817402skeen
skein94814402skein
skew116218762skew_
skews125413802skews
skin85927522skin
slew76228232slew_
slews86220352slews
smew95017732smew_
smews104612292smews
son37761952s_on
soon46240502soon
sorn46641062sorn
sow66554762sow_
sows75342492sows
span65234662span
spawn107811712spawn
spean74620512spean
spew95421872spew_
spews105015922spews
spin66231302spin
spun66221462spun
stein54620532stein
stern55319122stern
stew77525462stew_
stews85519142stews
stewy116112062stewy
strewn96710002strewn
stun45623452stun
sun37149032s_un
sunn45423592sunn
swan76631312swan
syn67024122s_yn
teen45938202teen
ten35856112te_n
tern46134802tern
tew66640152tew_
tews76431642tews
town76928702town
unsewn9298392unsewn
vein75625752vein
wean75734352wean
ween75835462ween
wen66249602we_n
yawn106219092yawn
yean75834582yean
yen66847382ye_n
yew96436292yew_
yews105323962yews
zein135620602zein

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 Filter178691298720.0762351197.4
2DLD Change Limit298721970.89333451.3
3Display Results1971970.0464282.6
 (SQL Overall)1786911971.015176050.2
 
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.