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

173 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
threaded136632(None) 
threader1256731threader
threaped1454861threaped
threated1259201threated
treaded95014281t_readed
breaded115014062_breaded
dreaded103612022_dreaded
headed114020472_h_eaded
phreaked1834492phreaked
rethreaded1543272rethreaded
shredded1444062shredded
thrawed1435582thr_awed
thread105011092threa__d
threaders1365742threaders
threadier1354472threadier
threads11419952thread_s
thready14435902thread_y
threaper1345142threaper
threaten1146302threaten
threeped1454372threeped
threshed1535642threshed
throated1247922throated
traded85717682t_r_aded
treader84113832t_reader
treadled1067122t_readled
treated83618702t_reated
trended94011762t_rended
unthreaded1543532unthreaded
abraded1138643abr_aded
airheaded1443953airheaded
arcaded1178973_arcaded
beaded104922423__beaded
beheaded1536373beheaded
bereaved1446403bereaved
breamed124011593_breamed
cheated134416343ch_eated
coheaded1536603coheaded
corraded12128293corraded
creaked143413233_creaked
creamed123913713_creamed
creased104315583_creased
created104323453_created
deleaded1148333deleaded
dreamed114310633_dreamed
fatheaded1744273fath_eaded
freaked15399703_freaked
gheraoed1343343gheraoed
graded94919553_gr_aded
greased93812393_greased
greaved12408913_greaved
haded105227623_h__aded
headend12398363_h_eadend
header104422543_h_eader
healed105121443_h_ealed
heaped124516903_h_eaped
heated104525593_h_eated
heaved134717863_h_eaved
heeded114215763_h_eeded
heralded1335443_heralded
herded114215643_h_erded
hotheaded1744853hoth_eaded
kneaded13146473_kneaded
leaded84221543__leaded
paraded114014263par_aded
pervaded1535373pervaded
phrased1387383phr_ased
phreaker1735053phreaker
pleaded113511263_pleaded
preaged11612333_preaged
prefaded1537823_prefaded
readd74617133__read_d
readded103310733__readded
reader73628293__reader
readied93316623__readied
reamed94326123__reamed
reaped94122453__reaped
reared75930013__reared
reaved104523923__reaved
redded94019553__redded
reded74829123__re_ded
reeded84022563__reeded
rended84524103__rended
retreaded1137053retreaded
screaked15246983screaked
screamed13277603screamed
screeded1235643screeded
serenaded11215933serenaded
shaded114518873sh__aded
sheafed14388973sh_eafed
sheared114516003sh_eared
sheaved143411633sh_eaved
shedded13419063sh_edded
shielded1334393shielded
shredder1334403shredder
shrewder1534403shrewder
shrewed14589853shre_wed
shrouded1333603shrouded
spreader1137483spreader
steaded92811673_steaded
streaked13228453streaked
streamed11258903streamed
teamed95418593t__eamed
teared75722153t__eared
teased74721153t__eased
teated74924023t__eated
tedded93810903t__edded
tended83819483t__ended
terraced11318123terraced
thawed13458463th__awed
theater104014253th_eater
themed125912583th_e_med
thieved1434973thie_ved
thralled1245803thralled
thrashed1555363thrashed
thrave126010273thr_ave_
thraves13469713thr_aves
threadfin1641953threadfin
threadiest1444283threadiest
threading14107593threading
threadless1442473threadless
threap11569663threa__p
threapers1444773threapers
threaps12488643threa_ps
threat95020463threa__t
threatened1442773threatened
threatens1254673threatens
threats104311673threa_ts
three87526913thre__e_
threep115910113thre__ep
threes97117323thre__es
threnode1255423threnode_
threnodes1354963threnodes
thresher1455823thresher
threshes1437383threshes
thrilled1235493thrilled
thrived14458183thr_ived
throbbed1643163throbbed
throned115412173thr_oned
thronged13405333thronged
thrummed1642843thrummed
thrusted1265223thrusted
thudded1333433th_udded
tirade7311693tir_ade_
tirades8311723tir_ades
tireder837703tire_der
toreador945003toreador
torsade837593torsade_
torsades937213torsades
towheaded1742823towheaded
traced94821583t_r_aced
trade65026043t_r_ade_
trader75218763t_r_ader
trades75724503t_r_ades
tread64821703t_rea__d
treaders93311843t_readers
treadle8310103t_readle
treadler936863t_readler
treadles939703t_readles
treads74817923t_read_s
treater74219833t_reater
trebled1038483t_rebled
treddled1134473t_reddled
treed65626733t_re__ed
trekked1134343t_rekked
tressed83714263t_ressed
triaged92810443t_riaged
troaked12438253t_roaked
turbaned1145623turbaned
tweaked1534403t_weaked
unleaded10411333unleaded
untreaded1137983untreaded
upreared1137073upreared
wreaked15369023_wreaked

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621736.70321805.5
3Display Results1731730.0632746.0
 (SQL Overall)1786911737.17224915.1
 
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.