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

121 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
website123532(None) 
websites1335181websites
felsite1039082felsite
hessite1038992hessite
resite64128452re_site
subsite9412872subsite
weblike1635922weblike
webster1236092webs_ter
wellsite1145132wellsite
albite8313313alb_ite
amosite9313163amosite
beastie92412433beastie
bedside1156843bedside
bedsit9312843bedsit_
bedsits1037563bedsits
beside95114613be_side
bite66547003__b_ite
blite76225353__blite
boite74426323__boite
cerite84724873ce_rite
cerusite1047763cerusite
coesite9713623coesite
debate94419193deb_ate
debit85727853deb_it_
debited113311623deb_ited
debits94214503deb_its
debride1138593debride
density1137583density
depside1138403depside
desire7415303de_sire
despite10410123despite
ebonite9310293_ebonite
elite56230183_e_lite
endite73817593_endite
ensile62616473_ensile
eosine64519413_eosine
evite85317683_e_vite
excite15310883_excite
febrile1237153febrile
felsites1138073felsites
ferrite103312753ferrite
geste65920693ge_s_te
gibbsite1342503gibbsite
gobshite1443273gobshite
hessites1138613hessites
inosite7314063inosite
kebbie1435813kebbi_e
kernite1159473kernite
lenite6719983le_nite
leucite937753leucite
lewisite1154543lewisite
newsie9138213newsi_e
obesity1275653obesity
pelite84323003pe_lite
penlite9313243penlite
pensile92713543pensile
pensive122610393pensive
pepsine11310603pepsine
perlite9317323perlite
petite84320653pe_tite
rebait8320403rebait_
rebaited11410543rebaited
rebaits9312573rebaits
rebate84424113reb_ate
recite83625113re_cite
requite162012483requite
reside74224933re_side
resile64627673re_sile
resit54241043re_sit_
resited85122423re_sited
resites74027793re_sites
resits64725563re_sits
resize154117723re_size
respite9513033respite
reunite7312713reunite
rewrite10311143rewrite
seaside839693seaside
sensate7311893sensate
sessile739523sessile
site47052413___site
subside10410453subside
subsites10312783subsites
tectite9310583tectite
tektite1136883tektite
tensile72612733tensile
tensity1039103tensity
tensive10269913tensive
teosinte845543teosinte
tergite8311003tergite
termite9313893termite
verite94323443ve_rite
versine102515173versine
verste94515633vers_te
waste86125053w_as_te
wayside1435183wayside
weakside1642843weakside
webbier1445423webbier
webbing1536123webbing
webfeet1544593webfeet
webpage1543133webpage
webs96622123webs___
websters1335803webs_ters
wedgie11428373wedgi_e
weenie92612023weeni_e
weepie11258793weepi_e
weest85026773wees_t_
wellie92814913welli_e
wellsites1244673wellsites
weskit1338343weskit_
weskits1434743weskits
west75748083we_s_t_
wester94222893we_s_ter
wests85727003we_s_ts
wetsuit1045453wetsuit_
wetsuits1143233wetsuits
white114920303w__hite
wite75443273w___ite
write85522833w__rite
zebrine1836463zebrine
zeolite1638903zeolite
zoisite1635833zoisite

Search took 9 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.406440125.6
2DLD Change Limit1340271218.06316622.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.51520985.4
 
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.