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

109 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
thymols153384(None) 
thymol1434461thymol_
chymous1775702chymous
cymols1377192_cymols
phytols15276552phytols
thiols95112762th_iols
thymes144810742thym_es
thymus14324742thym_us
chamois143512193chamois
chemos13311723chemo_s
chylous15107273chylous
chymes165912153chym_es
chymics19295533chymics
cymol1287623_cymol_
cymous1388403_cymous
ethanols1144333ethanols
ethyls1235903ethy__ls
ethynyls1741873ethynyls
etymons1244153etymons
formols12299413formols
ghylls1335143ghy_lls
glycols1344133glycols
hamals114816823_hamals
haymows1883813haymows
hols76946293_h__ols
homos105921783_homo_s
humors11129633_humors
hymens1437993_hymens
hymnals1543523_hymnals
hymns1337523_hym_ns
hypos1312014743_hypo_s
hysons1237633_hysons
mols65948573___mols
osmols8137313_osmols
phenols1238103phenols
phyllos1535583phyllos
phytol14366563phytol_
phytons15319063phytons
rhymers15365543rhymers
rhymes14419823rhym_es
rhytons13295883rhytons
shamois123210423shamois
shamos114216983shamo_s
shamoys15367283shamoys
sheols94614163sh_eols
shmoes114612103sh_moes
shools94919013sh_ools
symbols1435523_symbols
tallols73311363tallols
tamals84116633t_amals
taxols13328633t_axols
termors94712773termors
theelols1144413theelols
themes115319253them_es
thermals13518533thermals
thermels13607763thermels
thermos124610753thermo_s
thiazols2042473thiazols
thills95515383th_ills
thimble1435873thimble
thimbles1536023thimbles
thiol87616043th_iol_
thirls95012063th_irls
thole85620843th__ole
tholes94919783th__oles
tholos94213003th__olos
thorons104511913thorons
thous86017263th__ous
thralls10299043thralls
thrills10398783thrills
throbs118311373th_robs
throes97518673th_roes
throws129715233th_rows
thumbs13377443thum_bs
thumps13449353thum_ps
thurls9418713th_urls
thyme134612473thym__e
thymey17426313thym_ey
thymi13418633thym__i
thymic16307423thym_ic
thymier1534393thymier
thymiest1634733thymiest
thymine1536643thymine
thymines1635613thymines
thymosin1644493thymosin
thymosins1744203thymosins
thymuses1643073thymuses
thymy16437923thym__y
thyroid1438253thyroid
thyroids1546003thyroids
thyrses1335023thyrses
thyrsus1342693thyrsus
thyself1643033thyself
toluols735823toluols
tools55325243t__ools
toyons95512133toy_ons
toyos87519143toy_o_s
tramels93812493tramels
tremolo946513tremolo
tremolos1046043tremolos
tremors93711233tremors
triols66117803t_riols
tumors8810613t_umors
turmoils1043983turmoils
tymbals14265723t_ymbals
typos106015813t_ypo_s
tyros85118593t_yro_s
wadmols1333913wadmols
xylols1634173_xylols

Search took 7 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.423422437.4
2DLD Change Limit1340271095.87322820.9
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.32628247.1
 
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.