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

179 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
dangering1223930(None) 
angering102113801_angering
daggering13246111daggering
dandering122511061dandering
angeling102811732_angeling
badgering1436972badgering
bannering12208812bannering
bantering122414242bantering
cankering162110792cankering
cantering122417382cantering
dackering1737392dackering
daikering1536102daikering
danging103716092dang__ing
dangling112611232dang_ling
daundering1364462daundering
endangering14133512endangering
fingering1439192fingering
gandering122111292gandering
gingering1238872gingering
hangaring1438032hangaring
hankering17239382hankering
hungering14187682hungering
laagering1136832laagering
lagering102212312la_gering
lingering11310512lingering
mongering13310352mongering
pandering133211962pandering
saggering12197792saggering
tangerine1048402tangerine
wagering13219522wa_gering
wandering143310982wandering
adhering1338883_adhering
ageing84213403_a_ge_ing
algerine9810283_algerine
altering91917123_altering
anearing9413973_anearing
aneling82719503_an_eling
angling92816043_ang_ling
annexing1635473_annexing
anserine8313093_anserine
answering1345803_answering
anteing8312813_ante_ing
auguring1036383_auguring
banging114019863bang__ing
barbering14229693barbering
bartering122313653bartering
battering122715153battering
bingeing12237643binge_ing
buggering1435193buggering
bunkering16207103bunkering
cageling12310843ca_geling
cambering16109873cambering
canceling14310163canceling
canoeing11310213canoe_ing
capering132414963ca_pering
careering12311203careering
catering112019913ca_tering
centering122915143centering
changeling1745673changeling
cindering13311223cindering
clangoring1443913clangoring
congeeing1337903congeeing
daggling12237063da_ggling
dampening1535463dampening
dancing113611563dan__cing
dandling112511733dan_dling
danger83722833danger___
dangered11248513danger_ed
dangerous1146103dangerous
dangers94818213danger__s
daring84928683da___ring
darkening1535683darkening
davening13258873da_vening
dayspring1642613dayspring
degerming1435753d_egerming
diapering1339033diapering
dickering1737463dickering
differing1746483differing
dinging103618613ding__ing
dithering1499853dithering
doddering1335183doddering
dogearing1235763d_ogearing
dowering132510613d_owering
dungeoning1342633dungeoning
dunging103012623dung__ing
entering91920053_entering
faltering132211123faltering
fathering161010093fathering
fingerings1545073fingerings
fingerling1544833fingerling
ganging103216193gang__ing
gangling112411403gang_ling
gangrening1342773gangrening
garnering11298093garnering
gartering112111593gartering
gathering1499463gathering
gendering12249753gendering
haltering132212013haltering
hammering1737633hammering
hampering1738863hampering
hanging123518703hang__ing
hankerings18244753hankerings
hanseling1338063hanseling
havering152211053ha_vering
hindering14310273hindering
hunkering17227123hunkering
inhering12913713_inhering
jabbering2134443jabbering
jangling17249623jang_ling
jiggering1934303jiggering
kashering1736253kashering
lackering1639383lackering
laddering1237593laddering
lappering14258843lappering
lathering13912253lathering
laundering1245183laundering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
longeing10177593longe_ing
malingering1563193malingering
mammering1337333mammering
mangling122312623mang_ling
manuring1139223man_uring
mastering122315313mastering
mattering122314063mattering
maundering1455353maundering
meandering1446983meandering
nattering102212223nattering
paltering122612903paltering
pampering1638383pampering
paneling111013623pan_eling
panging113319113pang__ing
papering132213313pa_pering
pargeting1338283pargeting
pattering122314433pattering
paupering1437273paupering
pondering132411333pondering
ranging94120263rang__ing
rendering112213183rendering
rogering10310273_rogering
sabering112113743sa_bering
saggaring12236243saggaring
sanderling1256653sanderling
sauntering1137223sauntering
singeing10209933singe_ing
sintering101014803sintering
slandering1237243slandering
sneering93414503_sneering
staggering13194583staggering
strangering1345193strangering
sundering11312323sundering
swaggering16233623swaggering
tabering112211423ta_bering
tampering1438453tampering
tangerines1147543tangerines
tanging93419533tang__ing
tangling101712543tang_ling
tangoing10177893tang_oing
tapering112112503ta_pering
targeting1137303targeting
tattering102212333tattering
tendering112210813tendering
tentering102313213tentering
tingeing10198553tinge_ing
tinkering1437703tinkering
unageing1036273unage_ing
veneering1337663veneering
wafering15208893wa_fering
waitering13310723waitering
wanderings15215833wanderings
wangling132310993wang_ling
watering122316323wa_tering
wavering152410543wa_vering
wintering13412363wintering
wondering142110463wondering
yabbering1734023yabbering
yammering1735193yammering
yattering132410453yattering

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.423422437.4
2DLD Change Limit1486411797.47019898.4
3Display Results1791790.0762355.3
 (SQL Overall)1786911797.96922423.3
 
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.