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

100 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
thionine118792(None) 
ethionine1274861ethionine
thionin1048671thionin_
thionines12106971thionines
thionins1177921thionins
ethionines1394032ethionines
methionine1554552methionine
thiamine1346772thiamine
thiazine2045252thiazine
thinning12319092thinning
thionate11137502thionate
thionic1238892thioni_c
threonine1245102threonine
throning1238862throning
asinine7310723asi_nine
chining133316843chi_ning
chinning14329653chinning
chinone12510153chi_none
chlorine133013303chlorine
choline122915383ch_oline
chopine143512263ch_opine
chorine123218363ch_orine
conine84528553__conine
deionize1858683deionize
hipline12311423_hipline
hircine1239143_hircine
honing103421503_h_oning
hyenine1336953_hyenine
iodine74618653__iodine
ionise63516943__ionise
ionize154613873__ionize
ionone6313443__ionone
leonine7311233_leonine
lionise7310373_lionise
lionize1668823_lionize
methionines1653603methionines
pavonine1346663pavonine
phocine1438833ph_ocine
phoning13312053ph_oning
pyronine1349513pyronine
quinine163011043qui_nine
saponine1039223saponine
shining113816523shi_ning
shinning123211023shinning
taborine102510683taborine
taconite1049313taconite
tenoning938893tenoning
thebaine1355423thebaine
theine94814923th__eine
theorise1137873theorise
theorize2047073theorize
thiamin1236933thiamin_
thiamines1446383thiamines
thiamins1346633thiamins
thiazide2143033thiazide
thiazin1945483thiazin_
thiazines2144643thiazines
thiazins2045313thiazins
thieving1535143thieving
thine85026863th___ine
thinking16289863thinking
thinned11399163thi_n_ned
thinner10358973thi_n_ner
thinnish1454873thinnish
thiolic1247323thioli_c
thionates12106663thionates
thionyl1343713thion_yl
thionyls1442943thionyls
thiophen1643583thiophen
thiophene1744763thiophene
thirling12248583thirling
tholing112812333th_oling
thorite10313443th_orite
thorning1237513thorning
thouing11258603th_ouing
threonines1344553threonines
throne98517603thro__ne
thronging1435073thronging
throwing1536723throwing
thymine1536643th_ymine
thyroxine2243913thyroxine
tining74927543t_i_ning
tinning83117283t_inning
toning74025793t__oning
tonne54921433t__on_ne
tontine72316143t__ontine
toonie63617993t_ooni_e
toxine133114123t__oxine
triazine1738503triazine
tricotine1148253tricotine
trining82919213tri_ning
trioxide1644793trioxide
tropine93116653t_ropine
twining113211443twi_ning
twinning12367043twinning
twoonie1034423twooni_e
tyrosine1147043tyrosine
unionise847863unionise
unionize1747063unionize
whining143311673whi_ning

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621006.50022486.5
3Display Results1001000.0333030.3
 (SQL Overall)1786911006.95325699.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.