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 “thionyls” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

37 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
thionyls144294(None) 
thionyl1343711thionyl_
ethinyls1442872ethi_nyls
thiols95112762thio__ls
thionins1177922thionins
chromyls18244733chromyls
ethinyl1343433ethi_nyl_
ethions1038483ethion__s
ethnonyms1752183ethnonyms
ethoxyls2142213eth_oxyls
ethynyls1741873eth_ynyls
nonyls957853__nonyls
phenyls1534333ph_enyls
thiazols2042473thiazols
thills95515383thi__lls
things104914303thi_n_gs
thinks134613363thi_n_ks
thinly1238673thi_n_ly
thinners11327763thinners
thinness11277173thinness
thins85826333thi_n__s
thiol87616043thio__l_
thionate11137503thionate
thionates12106663thionates
thionic1238893thion_ic
thionin1048673thion_in
thionine1187923thionine
thionines12106973thionines
thirls95012063thi__rls
thongs104611193th_on_gs
thrones105715843thron_es
throngs11508163thron_gs
tolyls9436963t__olyls
toponyms1544463toponyms
triols66117803trio__ls
trotyls10236033t_rotyls
vinyls12467003_vi_nyls

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 Limit146162376.67321903.5
3Display Results37370.0162312.5
 (SQL Overall)178691377.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.