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

124 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
thymol143446(None) 
thymols1533841thymols
cymol1287622_cymol
phytol14366562phytol
thiol87616042th_iol
thyme134612472thym_e
thymes144810742thymes
thymey17426312thymey
thymi13418632thym_i
thymic16307422thymic
thymus14324742thymus
thymy16437922thym_y
chemo12313633chemo_
chemos13311723chemos
chyme156512503chym_e
chymes165912153chymes
chymic18317883chymic
chymous1775703chymous
cymols1377193_cymols
ethanol1044593ethanol
ethyl1136513ethy__l
ethynyl1642123ethynyl
etymon1134693etymon
formol112910333formol
ghyll1246323ghy_ll
glycol1254933glycol
hamal104623113_hamal
haymow1773683haymow
hemal104419803_hemal
homo96126473_homo_
homos105921783_homos
humor101110513_humor
hymen13311043_hymen
hymn12311313_hym_n
hymnal1434913_hymnal
hymns1337523_hymns
hypo127516353_hypo_
hypos1312014743_hypos
hyson1138693_hyson
mol56654593___mol
osmol7138573_osmol
phenol1149253phenol
phyllo1435873phyllo
phylon14318033phylon
phytols15276553phytols
phyton143610253phyton
rhyme13479553rhym_e
rhymed15416713rhymed
rhymer14387083rhymer
rhymes14419823rhymes
rhyton12356113rhyton
shamos114216983shamos
shamoy14379913shamoy
sheol84318373sh_eol
shmo95318103sh_mo_
shool84523153sh_ool
symbol1336083_symbol
tallol63612223tallol
tamal73522623t_amal
taxol124011363t_axol
termor84412513termor
thecal113310303thecal
theelol1044273theelol
them97427043them__
theme105921733them_e
themed125912583themed
themes115319253themes
thenal92712423thenal
thermal125010973thermal
thermel12569893thermel
thermos124610753thermos
thiazol1942623thiazol
thill85918733th_ill
thimble1435873thimble
thio77225413th_io_
thiols95112763th_iols
thirl85416823th_irl
tho67433963th__o_
thole85620843th__ole
tholoi9339233tholoi
tholos94213003tholos
thoro86217873thoro_
thoron94713903thoron
thou76722213th__ou
thrall93810293thrall
thrill94910593thrill
thro77726423th_ro_
throb109816853th_rob
throe89321423th_roe
throw118719733th_row
thumb124511283thum_b
thumbs13377443thumbs
thump126211573thum_p
thumps13449353thumps
thurl84912683th_url
thy97022913thy___
thymier1534393thymier
thymine1536643thymine
thymosin1644493thymosin
thyroid1438253thyroid
thyrse1235133thyrse
thyrsi1234453thyrsi
thyself1643033thyself
toluol636903toluol
tool46735683t__ool
toyo76925453toy_o_
toyon86715673toy_on
toyos87519143toy_os
tramel84113713tramel
tremolo946513tremolo
tremor84210403tremor
triol55521363t_riol
tryma1037223trym_a
tumor71110693t_umor
turmoil944723turmoil
tymbal13236823t_ymbal
typal105311153t_ypal
typo95418123t_ypo_
typos106015813t_ypos
tyro76622363t_yro_
tyros85118593t_yros
wadmol1234053wadmol
whamo135511263whamo_
xylol1546133_xylol

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127161244.61024450.3
3Display Results1241240.0304133.3
 (SQL Overall)1786911245.00035738.2
 
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.