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

129 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
threaping1510611(None) 
threading14107591threading
threating131010051threating
threeping15104801threeping
heaping133015852_h_eaping
phreaking1936472phreaking
reaping103621212__reaping
thrawing1535962thr_awing
threshing1645662threshing
throating1398402throating
treading103515332t_reading
treating92519612t_reating
beleaping1436743beleaping
bereaving1537573bereaving
breading123515463_breading
breaking153914253_breaking
breaming133612513_breaming
cheating144014523ch_eating
cheeping16329553ch_eeping
craping124018713_cr_aping
creaking153414123_creaking
creaming133413143_creaming
creasing113314443_creasing
creating113921953_creating
creeping133310103_creeping
creping122913653_cre_ping
draping114213353_dr_aping
dreading113712803_dreading
dreaming124011063_dreaming
freaking163611453_freaking
gheraoing1443523gheraoing
greasing102811393_greasing
heading122919113_h_eading
healing113922963_h_ealing
hearing113324163_h_earing
heating114024323_h_eating
heaving144114763_h_eaving
helping133512223_h_elping
leaping103215993__leaping
phrasing1438013phr_asing
phreakings2043193phreakings
prepping12309763_prepping
pretaping1439133_pretaping
raping94829853__r_aping
reading93327213__reading
reaming103924013__reaming
rearing83128783__rearing
reaving113820533__reaving
repping123314983__repping
rereading111212713rereading
retaping113012553__retaping
rethreading16154283rethreading
scraping133310863scr_aping
screaking16228243screaking
screaming14217833screaming
shaping133116183sh__aping
sheafing15329483sh_eafing
shealing123415463sh_ealing
shearing123915903sh_earing
sheaving154110253sh_eaving
shlepping1733393shlepping
shredding1544513shredding
shrewing15228093shre_wing
shrimping1734063shrimping
sneaping11349493_sneaping
spreading1339653spreading
streaking142010323streaking
streaming12239653streaming
taping94222393t___aping
teaming103917593t__eaming
tearing84021493t__earing
teasing83918513t__easing
temping122710693t__emping
terracing1237703terracing
terrapin1046203terrapin_
terrapins1146183terrapins
thawing14378683th__awing
theming133610473th_e_ming
therapies1447723therapies
therapist1447083therapist
thieving1535143thie_ving
thralling13256833thralling
thrashing1635683thrashing
threadfin1641953threadfin_
threadfins1741973threadfins
threadier1354473threadier
threap11569663threap___
threaped1454863threap_ed
threaper1345143threap_er
threapers1444773threapers
threaps12488643threap__s
threaten1146303threaten_
threatening1543063threatening
threatens1254673threatens
threonine1245103threonine
thrilling13276693thrilling
thriving15246353thr_iving
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throwing1536723thr_owing
thrumming1742903thrumming
thrusting1335013thrusting
thumping16296713th_umping
tracing103720153t_r_acing
trading93517973t_r_ading
tramping132711273t_ramping
trapping132911393t_rapping
treadling1137503t_readling
trebling1139873t_rebling
treeing83414303t_re_eing
trekking1235543t_rekking
trending103012833t_rending
trepang10257293t_re_pang
triaging102610543t_riaging
tripping133210923t_ripping
troaking133310973t_roaking
tromping13319603t_romping
trooping112710283t_rooping
trouping11249503t_rouping
trumping13308733t_rumping
tweaking1635883t_weaking
unthreading1644153unthreading
upheaping1743853upheaping
upleaping1434363upleaping
uprearing1238373uprearing
wheeping17337103wh_eeping
whelping17245333wh_elping
wreaking163010213_wreaking

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411296.31323545.2
3Display Results1291290.0632047.6
 (SQL Overall)1786911296.79926282.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.