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

114 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
thronging143507(None) 
throning1238861thron_ing
pronging123511842_pronging
thorning1237512thorn_ing
throating1398402throating
throbbing1743532throbbing
throwing1536722thro_wing
tonging93314512t__onging
wronging13327392_wronging
aproning11311793apron_ing
arranging1156303arranging
belonging1335913belonging
bonging113316373__bonging
bringing123011273_bringing
bronzing2037693_bronzing
changing153211513ch_anging
chroming163410723chro_ming
cringing123311383_cringing
deranging1238063deranging
dethroning1544743dethron_ing
droning93013723_dron_ing
enthroning1446033enthron_ing
fringing133010903_fringing
frogging14358733_frogging
fronting12310443_fronting
gonging103713033__gonging
hanging123518703_h_anging
hinging123917123_h_inging
hogging133112803_h_ogging
hongiing1335603_h_ongiing
honing103421503_h_on_ing
honking153414793_h_onking
horning113015003_horn_ing
inthroning1446223inthron_ing
ironing82414013_iron_ing
longing93915783__longing
phoning13312053ph_on_ing
phonying1745833ph_onying
ponging113416153__ponging
pranging123012723_pranging
progging132610383_progging
ranging94120263__ranging
ringing93521283__ringing
rouging93114703__rouging
scrouging1335263scrouging
scrounging1443353scrounging
shogging14308023sh_ogging
shrining122610853shrin_ing
shrinking1735653shrinking
shroffing1943313shroffing
shrouding1434753shrouding
shrugging1533703shrugging
sponging1238823_sponging
springing1338743springing
stringing1139753stringing
syringing1435883syringing
tanging93419523t__anging
tenoning938893tenon_ing
thanking16409523th_anking
thinking16289863th_inking
thinning12319093th_inning
thionin1048673thion_in_
thionine1187923thion_ine
thionins1177923thion_ins
tholing112812333th_o_ling
thouing11258603th_o_uing
thralling13256833thralling
thrashing1635683thrashing
thrawing1535963thr_awing
threading14107593threading
threaping15106113threaping
threating131010053threating
threeping15104803threeping
threonine1245103threon_ine
threshing1645663threshing
thrilling13276693thrilling
thriving15246353thr_iving
thrombin15104933thrombin_
thrombins1684713thrombins
throng10539973thro___ng
thronged13405333throng_ed
throngs11508163throng__s
throttling1442793throttling
thrumming1742903thrumming
thrusting1335013thrusting
thunking16196953th_unking
tinging93619463t__inging
togging103512743t__ogging
tonguing1046263t__onguing
toning74025793t__on_ing
trancing112812023t_rancing
trending103012833t_rending
triaging102610543t_riaging
trigging11299583t_rigging
trining82919213t_rin_ing
troaking133310973t_roaking
trocking153612423t_rocking
troking123514103t_ro_king
trolling93212493t_rolling
tromping13319603t_romping
trooping112710283t_rooping
trothing122410843t_rothing
trotting92510913t_rotting
trouncing1235153t_rouncing
trouping11249503t_rouping
trowing113413703t_ro_wing
trudging11266443t_rudging
turning83713183tur_n_ing
twanging13287063t_wanging
twinging13278423t_winging
unthroning1445493unthron_ing
whanging16267143wh_anging
whinging16247743wh_inging
wringing13279623_wringing

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.420425454.8
2DLD Change Limit1486411146.45323034.4
3Display Results1141140.0502280.0
 (SQL Overall)1786911146.92325811.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.