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

202 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
seaways1330751(None) 
seawans10379941seawans
seaway12309991seaway_
areaways1444482areaways
getaways1543342getaways
headways1845002headways
jetways2094052jetways
keyways2043372keyways
leeways1354452leeways
satays94411682s_atays
seabags1037482seabags
seawall1046202seawall
seawalls1145232seawalls
seawan94111222seawa_n
seawant103613412seawant
seawants11337972seawants
seaward1148172seaward
seawards1237202seawards
seaware1049622seaware
seawares1139332seawares
sewans95215902se_wans
sewars94018622se_wars
skyways2043222skyways
subways1536162subways
sways115518462s__ways
airways1336243airways
always12409133_always
anyways1644423anyways
areaway1335913areaway_
away108024223__away_
belays114313853be_lays
beltways1683903beltways
bendays13327513bendays
bendways1743733bendways
betrays12127823betrays
bewrays15145113bewrays
byways1734673_byways
caraways1636943caraways
castaways1743673castaways
cogways1634633cogways
cutaways1643813cutaways
decays124612913de_cays
deejays1843433deejays
deewans11306903deewans
defrays1436113defrays
delays104014053de_lays
derays105514253de_rays
dewans105215143de_wans
dewars105117073de_wars
embays131408323_embays
endways1444443endways
essays965653_essays
estrays10529403estrays
fadeaways1942233fadeaways
flatways1744323flatways
flyaways2042813flyaways
flyways19133853flyways
freeways1744723freeways
gamays126310903_gamays
getaway1444013getaway_
giveaways1951713giveaways
guanays1134953guanays
headway1745553headway_
hearsays1444513hearsays
hereaways1842763hereaways
heydays1734143heydays
hideaways1942453hideaways
jawans1657843_jawans
jetway19105273jetway_
keyway1943823keyway_
layaways1743403layaways
leastways1542313leastways
leeway1255883leeway_
logways1434513logways
midways16386183midways
nawabs1185063_nawabs
noways12127733_noways
oilways1334873oilways
peaveys15324063peaveys
reatas64021013reata_s
reawake14457893reawake
reawakes15348073reawakes
redbays1336013redbays
relays94316753re_lays
repays113813973re_pays
replays12399763replays
resays93714153re_says
roadways1564603roadways
runaways1442853runaways
runways13134443runways
sabals84618863s_abals
sagas66025883s_aga_s
salads75316963s_alads
salals65120083s_alals
sarans64224433s_arans
sashays1336333sashays
satay84718463s_atay_
savoys12427893s_avoys
sawers94620163s_awers
sawneys13274643s_awneys
saws75839483s_aw__s
says75942103s___ays
scalars93711903scalars
scarabs1137293scarabs
schwas14396983schwa_s
seabag938473seaba_g
seabeds10417223seabeds
seadogs958643seadogs
sealant73118303sealant
sealants82610743sealants
sealers74323553sealers
seals54839693se__als
seaman84015903seama_n
seamark1336723seamark
seamarks1445303seamarks
seamers94719433seamers
seams75731663se__ams
seamy105921273sea_my_
seances93015343seances
sears54744913se__ars
seas45755273se__a_s
seasons72614233seasons
seaters74028933seaters
seats54844343se__ats
seawater1136603seawater
seawaters1235693seawaters
seaweed11108813seaweed
seaweeds12104453seaweeds
secpars1138413secpars
sedans74816093se_dans
seesaws1034703seesaws
seggars9377783seggars
seitans73312303seitans
selahs9313213se_lahs
selvas93812913selva_s
sendals81912263sendals
sennas64214233senna_s
sepals85217373se_pals
sepias83616103sepia_s
sepoys1138473se_poys
seracs84418573se_racs
serais64326133se_rais
serdabs1035323serdabs
serials73919743serials
servals103410743servals
sewage10310733se_wage
sewages1139753sewages
sewan85921293se_wa_n
sewar85421093se_wa_r
sewers94719713se_wers
sews75836023se_w__s
sextans14349263sextans
shamans123610893shamans
shamas113717933shama_s
shamoys15367283shamoys
shawls125411973shaw_ls
shawms14579563shaw_ms
shaws116226263shaw__s
shays116021433s__hays
shipways1944073shipways
shwas116415103s_hwa_s
sideways1545233sideways
skidways1942823skidways
skyway1933343skyway_
slantways1542113slantways
slaveys13415203slaveys
slaws85222713slaw__s
slays85723683s__lays
slipways1643463slipways
snaws86116363snaw__s
someways1644823someways
sowans94215893s_owans
sowars94318003s_owars
spawns11577923spaw_ns
spays105520513s__pays
speedways1842553speedways
splays114910873s_plays
sprays115913643s_prays
stairways1582403stairways
stalags838643stalags
stays86022023s__tays
sternways1542593sternways
stowaways1842043stowaways
strays96417933s_trays
subway1447073subway_
sunrays1037083sunrays
swabs105817273s__wabs
swags94921253s__wags
swans84625013s__wans
swaps104819203s__waps
swats85726863s__wats
sway107128233s__way_
takeaways1942453takeaways
teapoys1235963teapoys
tearaways1542963tearaways
teaware1048143teaware
teawares1148083teawares
towaways1743633towaways
tramways1643723tramways
veejays2042313veejays
ways107737953___ways
wellaways1873163wellaways

Search took 10 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.296603685.8
2DLD Change Limit1340272029.28314437.9
3Display Results2022020.0762657.9
 (SQL Overall)1786912029.65518507.6
 
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.