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 “thronged” 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
thronged1340533(None) 
thonged12376841th_onged
throned115412171thron_ed
pronged113912392_pronged
thorned11479402thorn_ed
throated1247922throated
throbbed1643162throbbed
throne98517602thron_e_
thrones105715842thron_es
throng10539972throng__
throngs11508162throng_s
tonged86518902t__onged
wronged12397672_wronged
aproned10311503apron_ed
arranged1036933arranged
belonged1235313belonged
beringed1298173beringed
berouged1235323berouged
bonged105719603__bonged
bronzed19308213_bronzed
changed144214143ch_anged
chromed153510923chro_med
cringed113312403_cringed
deranged1137693deranged
dethroned1445073dethron_ed
droned84616863_dron_ed
enthroned1396883enthron_ed
fringed123611523_fringed
frogged13408493_frogged
fronded12388863_fronded
fronted114011273_fronted
gonged97115913__gonged
hanged114222393_h_anged
hinged114618923_h_inged
hogged125817773_h_ogged
honed95332263_h_on_ed
hongied12308163_h_ongied
honied104818393_h_onied
honked144517913_h_onked
horned105718703_horn_ed
inthroned1396583inthron_ed
ironed74916013_iron_ed
longed87121373__longed
phoned124014553ph_on_ed
phonied133710563ph_onied
ponged105619353__ponged
pranged114512553_pranged
progged12409803_progged
ranged84824313__ranged
ringed84623843__ringed
rouged86717323__rouged
scrouged1235383scrouged
scrounged1343143scrounged
shogged13397963sh_ogged
shrined114112413shrin_ed
shroffed1842563shroffed
shrouded1333603shrouded
shrugged1433673shrugged
sponged1137953_sponged
springed123911323springed
stringed102911873stringed
stronger9349693stronger
syringed13377583syringed
taloned8310223talon_ed
tanged84622493t__anged
tenoned839363tenon_ed
thanked15469153th_anked
thinned11399163th_inned
tholed105113873th_o_led
thong95014183th_ong__
thongs104611193th_ong_s
thornier1135323thornier
thoued10429003th_o_ued
thralled1245803thralled
thrashed1555363thrashed
thrawed1435583thr_awed
threaded1366323threaded
threaped1454863threaped
threated1259203threated
threeped1454373threeped
threnode1255423threnode
threshed1535643threshed
thrilled1235493thrilled
thrived14458183thr_ived
throbber1543203throbber
throe89321423thro__e_
throes97518673thro__es
thronging1435073thronging
throning1238863throning
throttled1352963throttled
through141647513throug_h
throve128012393thro_ve_
thrower1386993thro_wer
thrummed1642843thrummed
thrusted1265223thrusted
thunked15386853th_unked
tinged84220803t__inged
togged95117513t__ogged
toned65435343t__on_ed
tonger74719683t__onger
tongued946323t__ongued
tranced104414173t_ranced
trended94011763t_rended
triaged92810443t_riaged
trigged10359853t_rigged
trined74920713t_rin_ed
troaked12438253t_roaked
trocked144312243t_rocked
troked114114583t_ro_ked
trolled84312263t_rolled
tromped124210293t_romped
trone55131863t_ron_e_
trones65629283t_ron_es
trooped104010723t_rooped
trothed114010973t_rothed
trotted83711283t_rotted
trounced1135033t_rounced
trouped103910983t_rouped
trowed104714653t_ro_wed
trudged10298043t_rudged
trunked12358413t_runked
turned73914473tur_n_ed
twanged12387273t_wanged
twinged12398363t_winged
unthroned13106223unthron_ed
whanged15447613wh_anged
whinged15409153wh_inged
wringed123710193_wringed
wronger11288823_wronger

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 Limit1461621296.65621959.4
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.10825139.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.