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

149 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
throating139840(None) 
threating131010051threating
thrawing1535962thr_awing
threading14107592threading
threaping15106112threaping
throatier1244552throatier
throatily1543702throatily
throbbing1743532throbbing
thronging1435072thronging
throning1238862thro_ning
throttling1442792throttling
throwing1536722thro_wing
thrusting1335012thrusting
treating92519612t_reating
troaking133310972t_roaking
trotting92510912t_rotting
abrogating1497983abrogating
aerating92821003aer_ating
arrogating121778393arrogating
berating113220763ber_ating
bloating113512813_bloating
boating103721303__boating
borating113414503bor_ating
bromating1439183_bromating
cheating144014523ch_eating
chelating1549363chelating
chromatin16410753chromatin_
chromatins1749123chromatins
chroming163410723chro_ming
coating103525313__coating
coronating13410173coronating
corotating1349323corotating
crating103725203_cr_ating
creating113921953_creating
croaking153712163_croaking
curating11314293cur_ating
derating103222283der_ating
derogating1348633derogating
doating93816863__doating
enrooting10128133enrooting
ethylating1744783ethylating
floating123111883_floating
fronting12310443_fronting
frosting12311183_frosting
furcating1537783furcating
garoting10510703garo_ting
garotting1136103garotting
ghosting1336463gh_osting
gloating102611463_gloating
grating93923183_gr_ating
groaning102410283_groaning
grouting103410793_grouting
gyrating1337453gyr_ating
hating104929713_h__ating
heating114024323_h_eating
hoaxing18307763_h_oaxing
hooting113919883_h_ooting
hosting114318383_h_osting
hotting113116523_h_otting
iterating10314253iter_ating
lariating10311793lariating
moating104218153__moating
narrating10310353narrating
orating83520323_or_ating
perorating13313133perorating
phonating1537813phonating
phrasing1438013phr_asing
phreaking1936473phreaking
pirating11314513pir_ating
prating103424453_pr_ating
probating14311193_probating
pronating12313763_pronating
prorating12314283_prorating
rating74938703__r_ating
recoating121317463recoating
rerouting10311873rerouting
roaming103215793__roaming
roaring82916003__roaring
roasting93012703__roasting
rooting83522433__rooting
rotating92614553__rotating
rotting82919683__rotting
routing83821093__routing
seriating10916403seriating
serrating10513213serrating
shoaling123111753sh_oaling
shooting122812863sh_ooting
shorting122514803sh_orting
shotting123012383sh_otting
shouting122711793sh_outing
shroffing1943313shroffing
shrouding1434753shrouding
sprouting1236943sprouting
striating10914193striating
targeting1137303targeting
tarting84222653tar__ting
terracing1237703terracing
thawing14378683th__awing
thirsting1335283thirsting
tholing112812333th_o_ling
thorning1237513th_orning
thouing11258603th_o_uing
thralling13256833thralling
thrashing1635683thrashing
threaten1146303threaten_
threatening1543063threatening
threatens1254673threatens
threeping15104803threeping
threshing1645663threshing
thrilling13276693thrilling
thriving15246353thr_iving
throat94819753throat___
throated1247923throat_ed
throatiest1344953throatiest
throatiness1443583throatiness
throats104612193throat__s
throaty13428483throat__y
thrombin15104933thrombin_
thrombins1684713thrombins
throng10539973thro___ng
thrumming1742903thrumming
thwarting1632763thwarting
titrating10310113titrating
toasting93410583t__oasting
toiting83217093t__oiting
tooting83019423t__ooting
toting74123793t__o_ting
totting82816843t__otting
touting84118453t__outing
tracing103720153t_r_acing
trading93517973t_r_ading
treading103515333t_reading
triaging102610543t_riaging
trocking153612423t_rocking
troking123514103t_ro_king
trolling93212493t_rolling
tromping13319603t_romping
trooping112710283t_rooping
trothing122410843t_rothing
trouping11249503t_rouping
trowing113413703t_ro_wing
truanting1035603t_ruanting
trusting93411653t_rusting
trysting12267053t_rysting
uncoating12611923uncoating
unrooting1098833unrooting
uprating11311113upr_ating
uprooting1276903uprooting
variating13310953variating

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.453394461.4
2DLD Change Limit1486411497.04621095.8
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.56223630.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.