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

144 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
threading1410759(None) 
threaping15106111threaping
threating131010051threating
treading103515331t_reading
breading123515462_breading
dreading113712802_dreading
heading122919112_h_eading
phreaking1936472phreaking
reading93327212__reading
rereading111212712rereading
rethreading16154282rethreading
shredding1544512shredding
spreading1339652spreading
thrawing1535962thr_awing
threadfin1641952threadfin_
threadfins1741972threadfins
threadier1354472threadier
threeping15104802threeping
threshing1645662threshing
throating1398402throating
trading93517972t_r_ading
treadling1137502t_readling
treating92519612t_reating
trending103012832t_rending
unthreading1644152unthreading
abrading1239503abr_ading
arcading1239763_arcading
beading113221863__beading
beheading1636163beheading
bereaving1537573bereaving
breaking153914253_breaking
breaming133612513_breaming
breeding123411843_breeding
cheating144014523ch_eating
coheading1636623coheading
coleading1338523coleading
corrading1338203corrading
creaking153414123_creaking
creaming133413143_creaming
creasing113314443_creasing
creating113921953_creating
deleading1237773deleading
dreaming124011063_dreaming
freaking163611453_freaking
gheraoing1443523gheraoing
grading103918713_gr_ading
greasing102811393_greasing
hading113922943_h__ading
headings133510493_h_eadings
healing113922963_h_ealing
heaping133015853_h_eaping
hearing113324163_h_earing
heating114024323_h_eating
heaving144114763_h_eaving
heeding123515063_h_eeding
heralding1435773_heralding
herding122915123_h_erding
kneading1436373_kneading
leading93419553__leading
lipreading1444043lipreading
misreading1448263misreading
nonreading1246883nonreading
outreading1239283outreading
parading12313863par_ading
pervading1636303pervading
phrasing1438013phr_asing
phreakings2043193phreakings
pleading123011443_pleading
prefading16149033_prefading
readding11411363__readding
readings103512643__readings
readying13410223__readying
reaming103924013__reaming
reaping103621213__reaping
rearing83128783__rearing
reaving113820533__reaving
redding103218513__redding
reding83825563__re_ding
reeding94124133__reeding
rending93924263__rending
rereadings12124543rereadings
retreading12128483retreading
screaking16228243screaking
screaming14217833screaming
screeding1336323screeding
serenading1246103serenading
shading123115563sh__ading
sheafing15329483sh_eafing
shealing123415463sh_ealing
shearing123915903sh_earing
sheaving154110253sh_eaving
shedding14278113sh_edding
shending132511253sh_ending
shielding1434553shielding
shrewing15228093shre_wing
shrouding1434753shrouding
steading103613593_steading
streaking142010323streaking
streaming12239653streaming
teaming103917593t__eaming
tearing84021493t__earing
teasing83918513t__easing
tedding103210883t__edding
tending94419163t__ending
terracing1237703terracing
thawing14378683th__awing
theming133610473th_e_ming
thieving1535143thie_ving
thralling13256833thralling
thrashing1635683thrashing
thread105011093thread___
threaded1366323thread_ed
threader1256733thread_er
threaders1365743threaders
threadiest1444283threadiest
threadiness1543463threadiness
threadlike1841943threadlike
threads11419953thread__s
thready14435903thread__y
threaten1146303threaten_
threatening1543063threatening
threatens1254673threatens
threonine1245103threonine
thrilling13276693thrilling
thriving15246353thr_iving
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throwing1536723thr_owing
thrumming1742903thrumming
thrusting1335013thrusting
thudding1433983th_udding
tracing103720153t_r_acing
trebling1139873t_rebling
treddling1234423t_reddling
treeing83414303t_re_eing
trekking1235543t_rekking
triaging102610543t_riaging
troaking133310973t_roaking
tweaking1635883t_weaking
unleading1138673unleading
untreading1247563untreading
uprearing1238373uprearing
wreaking163010213_wreaking

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411446.57622603.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.07925242.4
 
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.