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

115 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
websites133518(None) 
website1235321website_
felsites1138072felsites
hessites1138612hessites
resites74027792re_sites
subsites10312782subsites
webster1236092webs_ter
websters1335802webs_ters
wellsites1244672wellsites
albites9313203alb_ites
amosites10311233amosites
beasties102514653beasties
bedsides1246533bedsides
bedsits1037563bedsit_s
besides104814533be_sides
bites75641173__b_ites
blites84721213__blites
boites84322703__boites
cerites94823433ce_rites
cerusites1146523cerusites
coesites101313093coesites
debates103718533deb_ates
debited113311623deb_ited
debits94214503deb_it_s
debrides1268723debrides
densities10310793densities
depsides1238503depsides
desires81316133de_sires
despites11410313despites
easies64126633_easi_es
ebonites1039233_ebonites
elites66027123_e_lites
endites83717063_endites
ensiles72714833_ensiles
eosines73718293_eosines
equites162212493_equites
evites94916473_e_vites
excites16310633_excites
felsite1039083felsite_
ferrites112312833ferrites
gestes75721393ge_s_tes
gibbsites1442013gibbsites
gobshites1542933gobshites
hessite1038993hessite_
inosites8312793inosites
kebbies1537253kebbi_es
kernites1269113kernites
lenites7818443le_nites
leucites1037333leucites
lewisites1244213lewisites
newsies101310383newsi_es
obesities1145843obesities
pelites93821993pe_lites
penlites10312273penlites
pepsines1239883pepsines
perlites10316363perlites
petites93820203pe_tites
rebaited11410543rebaited
rebaits9312573rebait_s
rebates95123183reb_ates
recites93524583re_cites
requites171511763requites
resides84523283re_sides
resiles74026543re_siles
resite64128453re_site_
resited85122423re_sited
resits64725563re_sit_s
resizes164216843re_sizes
respites10513243respites
reunites8312473reunites
rewrites11311063rewrites
seasides938743seasides
sensates8511143sensates
sites56045433___sites
subsides11410823subsides
subsite9412873subsite_
tectites1039993tectites
tektites1236613tektites
tensities9311333tensities
teosintes944553teosintes
tergites9310543tergites
termites10313693termites
testes65125823te_s_tes
velites103417303ve_lites
verites103822263ve_rites
versines112213823versines
verstes104014283vers_tes
wastes96224883w_as_tes
waysides1544453waysides
weaksides1742473weaksides
wearies103020223weari_es
webbier1445423webbi_er
webbiest1535353webbi_est
webbings1633243webbings
weblike1635923weblike_
webpages1643053webpages
wedgies123910213wedgi_es
weenies102915093weeni_es
weepies122811743weepi_es
wellies103719073welli_es
wellsite1145133wellsite_
welshes13379093wels_hes
weskits1434743weskit_s
wester94222893we_s_ter
westers105221963we_s_ters
wests85727003we_s_t_s
wetsuits1143233wetsuit_s
whites123919883w__hites
whosises1435333whosises
wites85536963w___ites
writes94420333w__rites
wussies103411083wussi_es
zebrines1935883zebrines
zeolites1738383zeolites
zoisites1744973zoisites

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621156.65621959.4
3Display Results1151150.0333484.8
 (SQL Overall)1786911157.10925135.9
 
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.