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

126 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
thyroid143825(None) 
theroid11313401theroid
thyreoid1544771thyreoid
thyroids1546001thyroids
thyrsoid1544191thyrsoid
choroid13311802choroid
euthyroid1653682euthyroid
hydroid1539712_hydroid
hyoid12612442_hy_oid
phytoid1678752phytoid
thyroidal1643282thyroidal
thyroxin2144182thyroxin
thyrsi1234452thyrsi_
toroid7416012t_oroid
acaroid103512313acaroid
ambroid1238883ambroid
amyloid1348543amyloid
android9311513android
aneroid8314003aneroid
aroid65428343__aroid
athetoid1246743athetoid
byroad1236623_byroad
cheloid13310833cheloid
chlorid133211843chlorid
choreoid1447923choreoid
chorioid1448333chorioid
choroids1438693choroids
chytrid1645733chytrid
cymoid1459473_cymoid
droid74218543__droid
elytroid1244963elytroid
emeroid101511183emeroid
ethmoid1345803eth_moid
euthyroids1752723euthyroids
fibroid1337243fibroid
haloid104317763_haloid
hemoid12313513_hemoid
heroic113516923_heroic
heroin94420593_heroin
horrid10311563_horrid
hyaloid1439073_hyaloid
hybrid15237813_hybrid
hydrid14248973_hydrid
hydroids1647763_hydroids
hyenoid1448613_hyenoid
hyoids1377673_hy_oids
hypnoid1647883_hypnoid
hypoed1547923_hypoed
hyracoid1745973_hyracoid
labroid1038823labroid
myoid11512993_my_oid
myxoid1936883_myxoid
negroid9108893negroid
neuroid81110303neuroid
ochroid1357903ochroid
phoronid1449073phoronid
phylloid1746193phylloid
pyoid11513763_py_oid
rhizoid2044583rhizoid
shroud1038773sh_roud
sparoid102311543sparoid
spheroid1447283spheroid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
styloid1137553styloid
tabloid1048263tabloid
tetroxid1646443tetroxid
thalloid1246283thalloid
therein102310353therein
thermic1439333thermic
thermit12312013thermit
theropod1445433theropod
third95912493thir__d
thirled11328093thirled
tholoi9339233tholoi_
thoria93012893thor_ia
thoric114314043thor_ic
thorned11479403thorned
thoro86217873thoro__
thoron94713903thoro_n
thorons104511913thorons
thread105011093th_read
thrip103012183th_r_ip
thro77726423th_ro__
throat94819753th_roat
throb109816853th_ro_b
throbs118311373th_robs
throe89321423th_ro_e
throes97518673th_roes
throne98517603th_rone
throned115412173th_roned
throng10539973th_rong
throve128012393th_rove
throw118719733th_ro_w
thrown1214911443th_rown
throws129715233th_rows
thylakoid2052053thylakoid
thymi13418633thy_mi_
thymic16307423thy_mic
thymol1434463thymo_l
thymols1533843thymols
thymosin1644493thymosin
thyroxine2243913thyroxine
thyroxins2243643thyroxins
thyrse1235133thyr_se
thyrses1335023thyrses
thyrsus1342693thyrsus
toroids8310643t_oroids
torpid9310913t_orpid
torrid7311853t_orrid
toxoid1438153t_oxoid
trod57627953t__ro_d
trois57226093t__rois
tuberoid1146013tuberoid
turbid979713t_urbid
turgid868013t_urgid
typhoid1648133typhoid
tyred95816433t_yr_ed
tyro76622363t_yro__
tyronic1239313t_yronic
tyros85118593t_yro_s
viroid10411523_viroid
xyloid1738193_xyloid
zebroid1936463zebroid
zygoid2045943_zygoid

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.423422437.4
2DLD Change Limit1340271266.03022226.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.49927495.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.