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

106 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
thiamin123693(None) 
thiamine1346771thiamine
thiamins1346631thiamins
thiazin1945481thiazin
diamin9312522_diamin
thiamines1446382thiamines
thiazine2045252thiazine
thiazins2045312thiazins
thionin1048672thionin
triazin1638202triazin
amin66042253___amin
chain105723673ch_a_in
chiasmi14365583chiasmi_
chiasmic17295023chiasmic
chiming153311833chi_ming
chirming16318643chirming
chitin113114963chi_tin
chitlin12269283chitlin
diamine10311983_diamine
diamins10312213_diamins
diazin1639163_diazin
etamin81311853_etamin
gamin84423003__gamin
gliadin935593gliadin
haemin113412663_haemin
harmin113117393_harmin
hemin103620933_h_emin
histamin1387043_histamin
hitman112710223_hitman
hitmen11239193_hitmen
hyalin122210043_hyalin
indamin1048043indamin
khamsin1643983kh_amsin
niacin8310223_niacin
rhodamin1443313rhodamin
saimin8313663sai_min
shaman113314283sh_aman
shaming133016743sh_aming
shimming16278253shimming
shipman14247133shipman
shipmen14317283shipmen
tailfin1035693tailfin
tain45548073t__a_in
takin94921303t__akin
tamarin9311913tamarin
tamein8313093t__amein
taming94023433t__aming
tamis76728733t__amis
tatami839193tatami_
tatamis939723tatamis
teaming103917593t_eaming
telamon936523telamon
thalami1246083thalami_
thalamic1545553thalamic
than76128773th_a__n
thawing14378683th_awing
theelin1038003theelin
thein85919023th__ein
theming133610473th_eming
therein102310353therein
theremin13107283theremin
thermic1439333thermic
thermion1345933thermion
thermit12312013thermit
thiaminase1552243thiaminase
thiazide2143033thiazide
thiazines2144643thiazines
thiazol1942623thiazol
thicken16317873thicken
thieving1535143thieving
thin76732393th___in
thinking16289863thinking
thinning12319093thinning
thiolic1247323thiolic
thionic1238893thionic
thionine1187923thionine
thionins1177923thionins
thiram1139963thiram__
thirams1236823thiram_s
thirling12248583thirling
thrawing1535963thrawing
thrawn12769423thra_wn
thrombin15104933thrombin
thymi13418633th_ymi_
thymic16307423th_ymic
thymine1536643th_ymine
tiepin839343t_iepin
tiffin12327933t_iffin
timid84815733t_i_mid
timing93619303t_i_ming
tinman82411143t_inman
tinmen82310403t_inmen
titman82711003t_itman
titmen8239883t_itmen
train56529113t_ra_in
triacid1038593triacid
triadic1037833triadic
triaging102610543triaging
triazine1738503triazine
triazins1738353triazins
trimming13318653trimming
trismic1137483trismic
twain86313623t_wa_in
tyramine1347303tyramine
vitamin1237423vitamin
wimmin1336153_wimmin

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.406440125.6
2DLD Change Limit1340271066.15621771.8
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.59227107.3
 
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.