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

115 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
thiolic124732(None) 
thionic1238891thionic
thallic1246552thallic
thiol87616042thiol__
thiols95112762thiol_s
thionin1048672thionin
thoric114314042th_oric
abiotic11510463abiotic
aioli5318313_aioli_
aiolis6316843_aiolis
anionic9312873anionic
avionic1237693avionic
bionic103614573_bionic
biopic123710673_biopic
biotic103816613_biotic
bucolic1345593bucolic
catholic15158383cath_olic
chaotic14310043chaotic
chili106218483chi_li_
chilis115517873chi_lis
chilli114312773chilli_
chillis124411603chillis
chitlin12269283chitlin
chloric143410613chloric
choric133515903ch_oric
chromic1639863chromic
chronic14311423chronic
colic95726173__colic
ecbolic1345623ecbolic
eidolic1047063eidolic
embolic1347423embolic
enolic8413353_enolic
epibolic1444913epibolic
ethylic1546323eth_ylic
exilic1597783exi_lic
folic105319323__folic
frolic1149203_frolic
ghibli1243493ghibli_
ghiblis1353343ghiblis
ghillie11326353ghillie
hili75626633_hi_li_
holmic1338783_h_olmic
hoolie93217783_hoolie
idiotic1037463idiotic
iodic84816753__iodic
ionic74622663__ionic
maiolica1244483maiolica
meiotic11410933meiotic
miotic103715753_miotic
niobic1037243_niobic
phallic1447293phallic
phenolic1546813phenolic
phimotic1747153phimotic
phobic153010073ph_obic
phonic133315213ph_onic
photic133316443ph_otic
phylic16279553ph_ylic
pionic103515953_pionic
rhizomic2442993rhizomic
rhodic12227233rh_odic
rhotic112711233rh_otic
sialic8313633_sialic
telic76019823t__elic
telomic1147603telomic
thalli958923thalli_
theelin1038003theelin
theistic1348153theistic
theodicy1742773theodicy
theolog1146153theolog
theologic1547503theologic
thermic1439333thermic
thetic11412893th_etic
thiamin1236933thiamin
thiazin1945483thiazin
thill85918733thi_l_l
thills95515383thi_lls
thinly1238673thinl_y
thio77225413thio___
thionine1187923thionine
thionins1177923thionins
thionyl1343713thionyl
thirl85416823thirl__
thirled11328093thirled
thirling12248583thirling
thirls95012063thirl_s
thole85620843th_ol_e
tholed105113873th_oled
tholes94919783th_oles
tholing112812333th_oling
tholoi9339233th_oloi
tholos94213003th_olos
thoria93012893th_oria
thulia936113th_ulia
thymic16307423th_ymic
toluic837693t__oluic
tonic74727653t__onic
topic95721503t__opic
toric76529313t__oric
toxic145315623t__oxic
triadic1037833triadic
triol55521363triol__
triolet73219523triolet
triols66117803triol_s
trioxid1546613trioxid
tripodic1345333tripodic
tripoli937133tripoli_
tripolis1038713tripolis
trismic1137483trismic
trisomic1245943trisomic
tropic103014193t_ropic
tufoli933973tufoli_
twilit949553twi_lit
tyronic1239313tyronic
violin9311983_violin
vitriolic1443033vitriolic

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271156.93619323.4
3Display Results1151150.0333484.8
 (SQL Overall)1786911157.35924282.0
 
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.