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

141 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
seawater113660(None) 
seawaters1235711seawaters
dewater112912422de_water
headwater1655032headwater
seafarer1144842seafarer
seamster1037142seamster
seater64534162se__ater
seaware1049632seaware_
seawares1139332seawares
sedater83713632se_dater
shearwater1652262shearwater
abater85518123__abater
awaiter1057443__awaiter
beater84729393be__ater
breakwater1952583breakwater
cutwater1344833cutwater
dealate83617843dealate_
dealated103213603dealated
dealates92716683dealates
debater104114693de_bater
deepwater1543713deepwater
defeater122611663defeater
deflater123211603deflater
dewaters122910723de_waters
easter65027983_ea_ster
eater54639843_e__ater
elater64724203_e_later
eyewater1444243eyewater
feaster10812983fea_ster
feater95224053fe__ater
graywater1643283graywater
headwaiter1752913headwaiter
headwaters1754253headwaters
heater94828303he__ater
jerkwater2341633jerkwater
meltwater1443433meltwater
neater64424313ne__ater
negater83711963ne_gater
newwaver1741963newwaver
overwater1538073overwater
pearter9412743pea_rter
pewter114013673pe_w_ter
placater1238013placater
realter73716313rea_lter
reawake14457893reawake_
reawaked16366623reawaked
reawaken15345563reawaken
reawakes15348073reawakes
rebater93517913re_bater
reheater113413033reheater
relater73723143re_later
repeater102615443repeater
rosewater1245023rose_water
salter64325083s_a_lter
saltwater1244353saltwater
saluter73512453s_aluter
saunter72913453s_aunter
savager1137133s_avager
savate9313783s_avate_
savates10312953s_avates
sawer85026213s_aw__er
sawyer12438043s_aw_yer
scamster1235303scamster
scanter94215183sca_nter
scatter93815173sca_tter
seafarers1244143seafarers
sealer63928963se__aler
seamer84223613se__amer
seamier93114633sea_mier
seamsters1136333seamsters
searcher13209103searcher
searer65432023se__arer
seasoner857693seasoner
seated75131063se__ated
seaters74028943se__aters
seatmate1048573seatmate_
seatmates1157823seatmates
seawall1046203seawa_ll
seawalls1145233seawalls
seawan94111223seawa__n
seawans10379943seawa_ns
seawant103613413seawa_nt
seawants11337973seawants
seaward1148183seawa_rd
seawards1237203seawards
seaway12309993seawa__y
seaways13307513seawa_ys
seaweed11108813seaw_eed
secateur1042923se_cateur
secreter1038513secreter
sedate73019813se_date_
sedated93714353se_dated
sedates83418043se_dates
seedeater1045973seedeater
semester1038903semester
senate63725173se_nate_
senates73322613se_nates
senator7313073se_nator
sensate7311893sensate_
sensated938193sensated
sensates8511143sensates
separate10310783separate_
separated1237713separated
separates11310743separates
separator1146263separator
septate9511873septate_
seriate73722473seriate_
seriated92717023seriated
seriates82620673seriates
serrate73017543serrate_
serrated92513433serrated
serrates82617023serrates
setter64023723se__tter
sewage10310733se_wage_
sewages1139753se_wages
sewar85421103se_wa__r
sewer84426223se_w__er
shatter103615703sha_tter
shearwaters1751973shearwaters
skater105015493s__kater
slater64429183s__later
smarter94113133sma_rter
smatter93613333sma_tter
spatter94016523spa_tter
spawner12347363spaw_ner
starter73817883sta_rter
stater64427563s__tater
stearate839723stearate_
stearates939453stearates
swager104013613s__wager
swather134213603s__wather
swatter104113323swa_tter
swayer125210973s__wayer
sweater103712723s_weater
teamaker1445113teamaker
teamster1036293teamster
teataster944563teataster
teaware1048143teaware_
teawares1148083teawares
water84733313___water
yeasayer1442353yeasayer

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621418.56317069.0
3Display Results1411410.0463065.2
 (SQL Overall)1786911419.02919790.8
 
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.